While trying to import/update some Contract records in my Salesforce system, I have run into issues with the formatting and consistency of currency fields.
If I update a currency field with the value 67539,00 then it appears in Salesforce as 6,753,900.00 (i.e. the figure gets multiplied by 100).
Why is this happening? How can I correct this?
- The locale for the system & user is set to English (United States)
- The value is formatted as text in my .csv file
- I need Salesforce recognise the commas as decimal places, but it refuses to do so.