I have a custom currency field Amount__c with Length 16, and decimal places 2.
I am trying to use Dataloader to update this field with negative numbers
I have placed the following negative number formats below in my CSV file but when I try to update the field, I get the error message " Amount: invalid Number"
-2122
I will appreciate the help
4 answers
Nathan,
FYI - I found the solution. When I deselect the "Use 1000 Separator (,)" check box in Excel, my currency values were updated in the amount__c field.
I appreciate your response. thanks.
