Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Removing Leading Zeros from a String
Greetings!
I have a worksheet which contains about 15000 rows, one column of which is a dashed number sequence. Example: 0000123-45-67 I would like to remove the leading zeros. Note that there are not always four zeros in front of the first number (sometimes there are more, sometimes less). Is there anything that can be done using VBA to remove the zeros? Thanks, MARTY |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Stop automatically removing leading zeros? | Excel Discussion (Misc queries) | |||
How do you stop excel removing the leading zeros in a cell? | Excel Discussion (Misc queries) | |||
Removing leading zeros from a group of numbers | Excel Discussion (Misc queries) | |||
removing leading zeros in numeric fields | Excel Discussion (Misc queries) | |||
save text field w/ leading zeros in .csv format & not lose zeros? | Excel Discussion (Misc queries) |