@Geert, You are correct, "10 550,50" imports fine. However my CSV file also has a currency symbol at the end (e.g. "10 550,50 USD"), and the imported numbers are then incorrect. I wish that Gnucash would ignore the text in the amounts! I assume that there is no option for this?
From: Geert Janssens [mailto:[email protected]] Sent: 11 May, 2022 02:27 To: [email protected]; [email protected] Cc: [email protected] Subject: Re: [GNC] Setting Currency Format when importing from CSV? I believe gnucash only cares about the decimal point separator and ignores the thousands separator. So for your example selecting "Comma" as currency format should work. At least it does in a quick test I just performed. Regards, Geert Op dinsdag 10 mei 2022 06:43:32 CEST schreef [email protected]: > The CSV Transaction Importer only has 3 options for currency format: Locale, > Comma and Period. Is there some way to change it to something else? > > > > For example in the CSV file, I have "10 550,50" which would translate to > "10,500.50" (in the US). Can I make GnuCash translate this properly? > > _______________________________________________ > gnucash-user mailing list > [email protected] > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. ----- > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. _______________________________________________ gnucash-user mailing list [email protected] To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. ----- Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
