csv format drops a text character when reopened in Excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Open CSV as txt data 5
How to prevent leading zero's from being dropped from a CSV file 1
How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1
Keeping lead zeros in excel text format when saving as CSV file 1
Excel CSV Files; Creating Of 3
Save As csv Carraige Return issue 3
Excel - CSV file, trying to save a date as text, reverts back to d 1
Why will Excel will not save text format in a .csv file 1

Back
Top