| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
in 2003 i have 0 text file conrt to 2007 number
i have a file in 2003 excel, one field is in text delimited format. How do i
convert this without lossing the '0' at the beginning of the number. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
in 2003 i have 0 text file conrt to 2007 number
Do you have an Excel file (.xls) or a CSV file?
If it's Excel, 2007 will read it in properly. If it's CSV, specify the field as text during the open. Regards, Fred "geordge7814" wrote in message ... i have a file in 2003 excel, one field is in text delimited format. How do i convert this without lossing the '0' at the beginning of the number. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Saving from 2007 to 2003 - 2003 won't open the file | Excel Discussion (Misc queries) | |||
| Saving Excel 2007 file in 2003 creates very large file | Excel Discussion (Misc queries) | |||
| Why can't I sort a 2003 file in 2007? 2007 freezes. | Excel Discussion (Misc queries) | |||
| How to tell number of spaces between values in saved text file fromthe original xls file | Excel Discussion (Misc queries) | |||
| 2003 file with VBA to 2007 | Excel Discussion (Misc queries) | |||
Linear Mode
