amounts multiplied by 100

amounts multiplied by 100

#23095
Closed (fixed) Opened

After some trial and issue I managed to generate acceptable conversion from CSV into a readable Microsoft Money-file QIF. But surprisingly the amounts (in Euro) were alle multiplied by 100 and needed manual correction.This probably caused by the fact that Money does not recognise a division by comma (example: 105,62), but needs a division by dot. (example: 105.62). The amounts generated appear as 10562. I already tried to restrict the formatting of the amounts to the unit: (example: 106), sacrifying some of the precision of the conversion, but it had no use, and gave me amounts like 10600.

Thanks on beforehand for any help

Jac*** Fri, 28 Apr 2017 - 16:10

Rather strange that no one can answer this issue afte more than one month.

CSV*** Fri, 25 May 2018 - 13:34

Please upload a bit of your CSV file, so we can debug it

CSV*** Thu, 14 Jun 2018 - 13:43

I have update some scripts, can you please try again

CSV*** Sun, 28 Oct 2018 - 01:50

Automatically closed - issue fixed for 2 weeks with no activity.