Converting a european format number to a US number
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
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