Home |
Search |
Today's Posts |
#1
|
|||
|
|||
prevent auto convert format
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 |
#2
|
|||
|
|||
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 "Zane" wrote in message ... |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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
CONVERT DATA TO CURRENCY FORMAT | Excel Discussion (Misc queries) | |||
CONVERT 11/23/04 US DATE FORMAT TO EUROPEAN 23/11/04 FATE | Excel Discussion (Misc queries) | |||
Time Format Auto Entry AM and PM | Excel Discussion (Misc queries) | |||
prevent 4/5 in a cell automatically transfer to a date format | Excel Discussion (Misc queries) | |||
Help Q: Entering 7 p time format, does not convert to 19:00 | Excel Discussion (Misc queries) |