| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to prevent leading zero's from being dropped from a CSV file
I have an excel spreadsheet that is formatted into a CSV file. When the CSV
file is created, the leading zeros are dropped. How can I prevent this from happening. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to prevent leading zero's from being dropped from a CSV file
Open the CSV file using Notepad to check if the leading zeros are
there. If they are, then rename the file to have an extension .txt, then from within Excel do File | Open - the Data Import Wizard will start automatically, and here (on the 3rd panel) you can specify which fields you want to be treated as Text. Hope this helps. Pete On Dec 18, 4:23*pm, Fun In The Sun <Fun In The Sun @discussions.microsoft.com wrote: I have an excel spreadsheet that is formatted into a CSV file. *When the CSV file is created, the leading zeros are dropped. *How can I prevent this from happening. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Leading Zero's in Excel | Excel Discussion (Misc queries) | |||
| Leading Zero's | Excel Discussion (Misc queries) | |||
| How to add leading zero's | Excel Worksheet Functions | |||
| Leading zeroes get dropped when converted to text | Excel Discussion (Misc queries) | |||
| Leading zero's | Excel Discussion (Misc queries) | |||
Linear Mode
