Hi.
Seems like a bug to me. Let's see if a moderator can inform the admin.
One correction, but the CSV file does not store formats, it is when importing to google that the currency format is created.
You have several ways to correct, one quite simple, is that you open the CSV file in a text editor and replace all the
,500,
by
,5.00,
before importing the CSV into google sheets.