prevent auto convert format

Z

Zane

I use program language dump a table in database to a csv file, some fields'
data type are "char";however,it's comprised of numeral, like "06885341".when
I open the csv file with excel, the "0" in the front of string disappeared.
How can I prevent it happen?
 
J

Jim Rech

Excel will always automatically convert numeric looking data to true numbers
when you open a CSV file. To stop it you must change the file's extension
to something else, like TXT. Then when you open the file in Excel the Text
Import Wizard will start up automatically. Use that to indicate the numeric
fields that should be treated as Text.

--
Jim Rech
Excel MVP
|I use program language dump a table in database to a csv file, some fields'
| data type are "char";however,it's comprised of numeral, like
"06885341".when
| I open the csv file with excel, the "0" in the front of string
disappeared.
| How can I prevent it happen?
| --
| Zane
 
Top