Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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) |