Can't retrieve data in CSV format

[Fanshawe]

Hello,

I'm having a problem saving my data in CSV files. I have barcodes that need to be imported into a windows system for a library. However when I save my file in CSV format, all the columns display 3E+11. I've tried to change the column format to "numbers", but it still doesn't do anything. The numbers are still being displayed in the formula but not on the sheet. I have a few thousand records, so manually retyping everything would be a big pain. Is there any way to resolve this problem? I need to import the data to fill in spots that were missed in the original import.

Any help ideas would be helpful.

Thank you

 

[Domenic]

Try changing the column format to "Text"...

 

[Fanshawe]

If I change it to "text" it changes to 3.0000E+11.