The file that exports payments, has a column in it called 'product price'. But rather than being formatted in a currency, it's just a number. When you convert that number in google sheets, it can't tell where a decimal would be. For me it shows '500' as the product price (it's suppose to be $5) and there's no easy way to convert this into $5 without some copy and pasting (I'm not a coder, maybe there's an easier fix). Every other column works as expected (there's at least a decimal where it should be)

If this is on purpose, I'd love to know why! 
If this is a bug, is it possible to fix? 

Thank you for your time. 

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.