CSV files
 

I saved an excel file as a CSV file and when I re opened it the formatting
had changed. Example : There was an ' before the numbers in the first
columnand now it is gone. How do I keep this from happening?

CSV files
 

a CSV file is the "data" from the Excel workbook *without* the formatting.
Excel tells you that you'll lose the "special features" when you save to a
CSV file, but in reality you'll lose the formatting too.

"jszuch" wrote:

I saved an excel file as a CSV file and when I re opened it the formatting
had changed. Example : There was an ' before the numbers in the first
columnand now it is gone. How do I keep this from happening?