Saving .csv files in Excel
June 30, 2011 1:06 PM Subscribe
About a dozen people have tried to solve this. All failed. Exporting from Excel to .csv causes cells to show #NAME? instead of the actual value.
The file was created by exporting the product options from a shopping cart application. This is a .xlsx file. It is the only way that I could figure out to keep the data from being altered.
Column O contains the product model number extensions. So on the front end if you select Natural Gas or Propane it appends a -NG or -LP to the root model number.
An easy way to make bulk changes to products/options/pricing/etc. is to export the corresponding file and change the data in Excel and then import the updated file.
The cart exports a .cvs files and will only import .cvs files.
When you open the exported file in Excel all of the occurrences of -NG/-LP have been changed to =-NG/=-LP and display as #NAME?. This happens even if you format column O to be text. I can do a replace and remove all the =, however when I save it as a .cvs file they are altered again.
I have tried this with Excel, Open Office Calc and Google docs. All of them produce the same results.
Does anyone know how to take the above file and save it as a .cvs without it adding a = to every cell whose contents begin with a -?