AnsweredAssumed Answered

Converting a european format number to a US number

Question asked by DickVerschuur on May 19, 2012
Latest reply on Sep 15, 2017 by taylorsharpe

Title

Converting a european format number to a US number

Post

Hello everybody

I need some help with a calculation field.

I have a number field that holds a calculated value.
The decimal separator is European: a comma.
Because it is a calculated value the number of decimals are not always 2:
It could be 1000,5 or 1000,52 or even 1000,5232198

My problem:
i need to export the field to a MySQL table
the format should then be: 1000.00 (US currency, with two decimals)

Can anyone help me with a calculation that:
- sets the number of decimals to 2
- converts the comma to a point


Great!

Dick

Outcomes