Trouble with csv import after edit in Google Sheets

Excursionist
21 0 3

Hi,

After exporting all products I opened up the file in Google Sheets. After some editing (just the description of all the products) I tried to import the file into Shopify again.
I got error saying that "549.07.00" is not a legal price.

Okey, opened the file again in Google Sheets and noticed that every price is now like 454.55.00 when it should be 454.55
It throws zeros after the price and it seems impossible to get rid of them. I have tried "search and replace", changing the format but the zeros are still there.
Anyone got similar problem with Google Sheets?

Please advice

t1.JPG

0 Likes