dot and comma to separate dollar and cents

u.brinkrode98571

Some colleagues in US or other countries all over the world capture data via a form into Smartsheet. Sometimes cents are neeeded so the dot will be used to separate the dollar from the cent.

My account is in Germany and the the Germans use the comma for separation not the dot.

All data run into a failure and I have to delete the dot and to enter a comma.

Within the form its only possible to proof for an amount not how much digits have to be captured on the right side of the comma.

How can I improve this.

Thanks for your comments

UWE

John Pudar

Hello @u.brinkrode98571,

There may be a better way to do this, but one solution would be to create a secondary column and enter this as a column formula:

=SUBSTITUTE([Name of Column]@row, ".", ",")

You could then utilize this column when exporting data to any application that requires commas.

u.brinkrode98571

The proposal works but isnt this a workload of the system?

Thanks a lot for your help

UWE