rgwhitaker Posted August 23, 2014 Share Posted August 23, 2014 I've finished creating a spreadsheet within Excel that I want to save as .CSV to import into PS. Problem is, I've read that you need to go into File > Options, then in the Advanced tab, unclick the Use system separators, and then enter a , (comma) in the Decimal separators box. I did that. Problem is, I have wholesale and retail prices as 29.95, 32.95, 44.95, etc. If I have the decimal separators set to a comma, then I get pricing like 29,95; 32,95; etc. I don't want that. Is there any way to get around this? I'm using PS 1.5.4.1. Link to comment Share on other sites More sharing options...
rgwhitaker Posted August 23, 2014 Author Share Posted August 23, 2014 OK. I solved this one. I simply kept the decimal separator as a comma, then exported the csv file, then opened it in Notepad. From there, since my prices were 29.95, but appearing as 29,95, I simply did a search on ,95 and replaced it with .95. Worked fine! Link to comment Share on other sites More sharing options...
Recommended Posts