| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Preserving '00nnnn' in xls to csv file saving
Excel 2003 SP3
I have a couple of columns, such as WorkType and ZipCode that have leading zeroes. For example, a ZipCode could be '00141', '02099' etc. and the WorkType could be '0800', '1000', '0100' etc. I've changed the column format from General to Special ('00000') and tried Text and also tried saving as CSV (MS-DOS). I can't setup the entire spreadsheet as Text or whatever because I have a column of dates and times, phone numbers, city, .... What's the way to save a spreadsheet so that my columns with leading zeroes in the cell don't get dropped? Seems easy and I remember doing this a while back but I can't seem to find the solution now....! :-( TIA! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Preserving '00nnnn' in xls to csv file saving
The leading 0's don't get lost when you saved the file as a .csv file. Use
notepad to check it out. But if you reopen that .csv file in excel, those leading 0's will be lost. Tom wrote: Excel 2003 SP3 I have a couple of columns, such as WorkType and ZipCode that have leading zeroes. For example, a ZipCode could be '00141', '02099' etc. and the WorkType could be '0800', '1000', '0100' etc. I've changed the column format from General to Special ('00000') and tried Text and also tried saving as CSV (MS-DOS). I can't setup the entire spreadsheet as Text or whatever because I have a column of dates and times, phone numbers, city, .... What's the way to save a spreadsheet so that my columns with leading zeroes in the cell don't get dropped? Seems easy and I remember doing this a while back but I can't seem to find the solution now....! :-( TIA! -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Confused here Prevent Saving File - but allow ONLY File SAVEAS Met | Excel Discussion (Misc queries) | |||
| Saving worksheet in new file with date AND cell value as file name | Excel Discussion (Misc queries) | |||
| Text file saving, setting file origin | Excel Discussion (Misc queries) | |||
| Excel should let me sort the file directory when saving a file | Excel Discussion (Misc queries) | |||
| How do I stop Excel 2000 from saving file history from file that . | Excel Discussion (Misc queries) | |||
Linear Mode
