I have a column of information that comes to me with extra zeros tacked
on the left side of the data. It is similar to:

002047
000301
000027

What I need is help inserting code in a macro that will make the
information look like:

2047
301
27

It has to be in a macro as this information interferes with a current
macro and needs be changed in the process.

The numbers can be as different as the ones above; where one cell may
have two zeros and the next may have one that need removed.

Thanks!


--
Kaziglu Bey
------------------------------------------------------------------------
Kaziglu Bey's Profile: http://www.excelforum.com/member.php...o&userid=36086
View this thread: http://www.excelforum.com/showthread...hreadid=571396