Why will Excel will not save text format in a .csv file

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

Guest

In Excel .csv file,

I format cell as text enter 001 and save. Reopen and everything is
reformatted as general and cell shows 1. Can this be fixed?
 
If you open the .csv file in notepad (or any other text editor), what do you
see.

Just because reopening the file in excel loses the leading 0's, it doesn't mean
the SaveAs didn't work correctly.

If you want to preserve formatting, then saving as a .csv file isn't the way to
go. If you want to see what the .csv file looks like, then reopening using
excel isn't the way to go.
 

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

How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1
csv format drops a text character when reopened in Excel 1
Converting numbers and number formatting to a CSV file ? 1
Excel CSV Files; Creating Of 3
Can Not get cell to accept any format change! Source from html 1
How to convert OST to PDF? Simple Methods 3
numbers convert to formula in csv 1
Save As csv Carraige Return issue 3

Back
Top