SAVING EXCEL FILE AS .CSV

D

Dwayne

I'm trying to save an excel file in .csv format with
Excel 2003. After I get out of the file and get back in
the format of the cells has changed. For instance, one
column has all 4 digit numbers most of which have "0" as
the first digit. The .csv file has omitted all of the
zero's. It has also changed several of the cells to a
date format. Does anyone have any ideas why this is
happening?

Thanks,
Dwayne
 
E

Earl Kiosterud

Dwayne,

It's probably not the saving as csv that's changing your data, but the way
Excel treats it when you reopen it with Excel. Try opening it with Notepad,
which will show you exactly what's in the file, character for character,
with no interpretation as with Excel. If Excel in fact isn't saving it the
way you need it, try the Text Write Program at www.tushar-mehta.com. It
writes a sheet to a text file with lots of options, and is easy to use.
 
D

Dwayne

Thanks Earl! I'll give it a try.

-----Original Message-----
Dwayne,

It's probably not the saving as csv that's changing your data, but the way
Excel treats it when you reopen it with Excel. Try opening it with Notepad,
which will show you exactly what's in the file, character for character,
with no interpretation as with Excel. If Excel in fact isn't saving it the
way you need it, try the Text Write Program at
Click to expand...
www.tushar-mehta.com. It
 
Top