| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Lead Zeros in Text
We want to use Text to Columns to divide a field with four digits into two
columns with two digits. If one of the digits begins with zero, this does not work - (the zero drops from the display). How do we retain the lead zero in the resulting cell? We have tried formatting the workbook as text prior to importing and afterward too, to no avail. FormatNumberCustom00 did nor work either. 'Suggestions? DOUG |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Keeping lead zeros in excel text format when saving as CSV file | Excel Worksheet Functions | |||
| Excel drops my lead zeros: need 0051 not 51 | Excel Discussion (Misc queries) | |||
| Keep Lead Zeros | Excel Discussion (Misc queries) | |||
| Deleting Lead Zeros | Excel Worksheet Functions | |||
| Lead Zeros to Show? | Excel Worksheet Functions | |||
Threaded Mode
