| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Keep Lead Zeros
I have a column of numbers with lead zeros, formatted as Numer PESEL. I need
to get these numbers into text format, but keep the lead zeros and I can't figure out how. When I double click on the cell, the zeros disappear. If I copy and paste to a text formatted cell, the zeros disappear. Any suggestions? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Leading Zeros | Excel Discussion (Misc queries) | |||
| Deleting Lead Zeros | Excel Worksheet Functions | |||
| How do I force leading zeros in an Excel cell? | Excel Discussion (Misc queries) | |||
| Lead Zeros to Show? | Excel Worksheet Functions | |||
| Help!: lead sheet data needs to fill appropriate subject sheets | Excel Worksheet Functions | |||
Threaded Mode
