When I open up the CSV file in Excel, and select a cell, the value in the function bar is correct, but the display on the spreadsheet is in exponential format. If I re-format the cells, the correct value is displayed.
If I just open the file, save and close it, and then re-import the CSV file back into my website, the invalid exponential number gets imported rather than my valid ISBN.
This becomes a problem because I have 3rd party sellers importing/exporting products at my marketplace, and I can't picture the average person figuring out how to reformat their Excel file when they edit products and re-import them into my site.
When someone exports a CSV file, my script automatically adds an equal sign and double quotes around my ISBN (like: ="9704322318673"). When they open the CSV in Excel, this becomes a function and displays just the number. When they save and re-import, my script automatically strips out any equal signs and double quotes from this column. Hopefully Excel is the only program that opens up CSV because of this function method.
Let me know what your thoughts or solutions are.