### 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

On one layout you can have multiple instances of the same number field. Eech instance can be formatted to display the number differently.

Google "number field formatting filemaker"

http://www.google.com/search?q=number+field+formatting+filemaker

http://dwaynewright.squarespace.com/filemaker-layouts/2008/4/20/filemaker-layout-number-field-formatting-options.html

Home > Designing and creating databases > Editing objects on layouts > Formatting and setting up field objects in Layout mode >

Specifying formats for fields containing numbers

Specifying formats for fields containing numbersTo display numbersDo this