View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
marty marty is offline
external usenet poster
 
Posts: 33
Default 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