| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to remove 0's in front of numbers?
I have a column of numbers, as below. How can I remove the 0 in front?
035000 035002 035006 035009 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| remove spaces in front of text | Excel Discussion (Misc queries) | |||
| Remove space in front of number in a cell? | Excel Worksheet Functions | |||
| Macro to remove space at front and end of a cell | Excel Discussion (Misc queries) | |||
| add zeros in front of numbers | Excel Discussion (Misc queries) | |||
| How do I keep zeros in front of other numbers (like a zip code)? | Excel Discussion (Misc queries) | |||
Threaded Mode
