Try saving the original file once more.

But don't reopen it in excel. Instead open it using NotePad.

Does it look ok there?



PTL wrote:

After I save the file as a csv it becomes exponential. If I open it it still
stays that way.

I need the csv file to not have exponential values in it so I can import it
into my erp system.

Thanks

"PTL" wrote:

I am trying to save an xls spreadsheet to a .csv file.

I have formatted one of my columns as text.

When I save the file as xls the data stays in tact.

When I save the file as csv that column changes values to exponential.

What am I doing wrong?

Thanks
--
PTL

--

Dave Peterson