CSV files

  • Thread starter Thread starter Barbara
  • Start date Start date
B

Barbara

We are having a problem with saving an Excel spreadsheet to CSV. The problem
is the spreadsheet has a column in it that contains a UPC number, which as
you know is very long. The action of saving this to CSV is causing the
number to convert to the Scientific formula number, for example:
12345678910111200000 in Excel will save in CSV as 1.23E+20.

How do we save a CSV file and have it save correctly?

This is urgent, so if you have any ideas please let me know.

Thank you.
 
Back
Top