| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to keep all leading zeros when stripping dashes from txt num
I have a text column that contains formatted numbers.
I need to strip the dashes, but preserve ALL numbers. When I use replace to strip the dashes, Excel automatically changes the cells to numbers format and I lose all the leading zeros. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Why do the preceding zeros disappear when I remove dashes? | Excel Discussion (Misc queries) | |||
| How can SS#s be displayed as text with all zeros and no dashes? | Excel Discussion (Misc queries) | |||
| Stop Excel from stripping out leading zeros when saving as CSV | Excel Discussion (Misc queries) | |||
| Stripping the dashes | Excel Discussion (Misc queries) | |||
| save text field w/ leading zeros in .csv format & not lose zeros? | Excel Discussion (Misc queries) | |||
Threaded Mode
