Decimal points dropping off amounts when uploading data file

Highlighted
Occasional Contributor

Decimal points dropping off amounts when uploading data file

I am uploading a .csv file with amounts that have dollars and cents.  Whether the columns in my module are set to use decimal places or not, it is not recognizing the cents.  1633.34 shows up like 163334 when no decimal places are formatted and 163334.00 when I use 2 decimal places.  Is there a way to see the amounts in the module with the decimal place correctly showing?

1 REPLY 1
Highlighted
Master Anaplanner/Community Boss

Re: Decimal points dropping off amounts when uploading data file

@Loraine 

A couple of things to watch

 

1. If you are saving from excel, ensure that the format is specifically forcing it to 2dp.  I recommend not using any delimiter for thousands.  I've seen it where the CSV doesn't save the decimals

2. Check the import settings for decimal delimiter in the initial mapping screen.  If they are not coming through it might be set to something other than "."

 

I hope that helps

David