csv format drops a text character when reopened in Excel
 

Saved worksheet as .csv format which contains a cell with the text characters
"01" (zero one). When the .csv file is opened in Notepad, the "01" displays
as it should, but when the .csv file is reopened in Excel the leading "0" is
gone.

The "01" is not "1" formatted as 0# or whatever, but is actual text.

The .csv file is for export to another party, and requires a 2-position field.

Any help is appreciated!

If Notepad sees 2 characters, then you have nothing to worry about. Excel
automatically imports as numbers, and will convert it, but if Notepad shows
it correctly, then that is the true value of the CSV file.
*******************
~Anne Troy

www.OfficeArticles.com


"RivRunR" wrote in message
...
Saved worksheet as .csv format which contains a cell with the text
characters
"01" (zero one). When the .csv file is opened in Notepad, the "01"
displays
as it should, but when the .csv file is reopened in Excel the leading "0"
is
gone.

The "01" is not "1" formatted as 0# or whatever, but is actual text.

The .csv file is for export to another party, and requires a 2-position
field.

Any help is appreciated!