Home |
Search |
Today's Posts |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Change the extension from .csv to .txt, then the text import wizard will
allow you to specify the format of the relevant columns as text. -- David Biddulph "Vincent" wrote in message ... I have a csv file with a text field enclosed with " ", the content of the field is numeric but with leading 0s'. When I Start MS Excel 2003 and then open the file, the field is converted to numeric and causes the leading 0 being dropped. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Auto-Open other file | Excel Discussion (Misc queries) | |||
How to format a number cell to auto count 1 up on file open | Excel Worksheet Functions | |||
How to auto activate macro when file open ? | Excel Worksheet Functions | |||
message/dialog box auto open when excel file is activated | Excel Discussion (Misc queries) | |||
How to auto-refresh Pivot data when open Excel file? | Excel Worksheet Functions |