If you open the .CSV file in Notepad, I bet your 16 digits show up nicely.

But if you reopen that file in excel, excel will try to make that field
numeric--and excel only supports 15 significant digits. (and will format it in
scientific notation to boot.)

If you have to reopen it in excel, you can rename that .csv file to .txt. Then
when you do File|open, you'll see the data import wizard. You'll be able to
specify that this field be text and your 16 digits will be kept nicely.

Jimv wrote:

I am trying to save an excell file as a .csv file. I have one cell that
contains a 16 digit number and it wont save as text. It turns into "7777+15".
How can I get it to save correctly.

thanks

Jim

--

Dave Peterson