Convert number format

[RDF25087]

Hi all -

I'm struggling to change a number from a continental format, e.g. 1.23,45 to a UK format e.g. 1,23.45. I'm sure this is fairly straight forward - but not for me!

Any help you could give would be greatly appreciated.

Thanks

RDF

[alexnajm]

@RDF25087 is this the output you are looking for?

[alexnajm]

Whether these are two separate numbers (1 and 23,45), this Formula should still work.

ToNumber(x, [bIgnoreErrors], [keepNulls], [decimalSeparator]): Converts a string (x), to a number. ToNumber accepts strings that can be interpreted as scientific notation double precision. By default, the period is used as the decimal separator.  Conversion Functions | Alteryx Help

[RDF25087]

Thanks for the reply. Almost! It seems to have converted 5.407,50 to 5407.5. I might be able to work with that but is there a way to add the "," back in, so that it would be 5,407.50?

[alexnajm]

It's possible yes, but the value would have to be stored as a string to keep the comma separator. Is this the preference?

Otherwise if it should stay as a number, I would just use the Number Separator toggle in the Results window or format it on the output side (i.e. Excel, Tableau, etc.).