How do I format a long number fields as text in an Excel .CSV file

C

Cyberscenes

I am creating an Excel .csv text file with a program and I am trying to
format a field that contains about 20 numbers as a text filed. When I open
the .csv file with Excell that column does not show correctly. It appears
that Excel is trying to treat it as a number. It tried bounding the field
with double quotes and that doesn't seem to make a difference. The filed
still shows up with an "E" towards the right end of the filed that I can't
make go away.
 
E

Earl Kiosterud

Cyber,

It's probably happening when you open the csv file with Excel, not when the
file was written. Open the file with Notepad. It will show you exactly the
characters in the file. More on text files and Excel at www.smokeylake.com.
Read "Text files".
 
D

Dave Peterson

If you have to open the .csv in excel, rename it to .txt.

Then file|open and you can specify the format that you want for each field
(text).
 
Top