| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Leading zeros won't convert to csv file in Excel ver 6 SP2
It does not matter if you had the leading zeros because the cell was formated
as text, or formatted as Custom 0000, or started with an apostrophe. After saving as .csv the zeros should still be there. Verify this by opening the .csv file with Notepad. Its when you re-open the file with Excel that the leading zeros get dropped. -- Gary's Student "Pedro" wrote: After formating the numbers for leading zeros and saving as a csv file, the leading zeros drop off. This process used to work fine for me and just quit doing it. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Convert CSV File Into Formatted Excel Document | Excel Discussion (Misc queries) | |||
| TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
| CSV File - Leading Zeros | Excel Discussion (Misc queries) | |||
| How do I force leading zeros in an Excel cell? | Excel Discussion (Misc queries) | |||
| Convert excel file to flat text file | Excel Discussion (Misc queries) | |||
Threaded Mode
