Column A of a varying number of rows have a 9 digit number leading wit
a Zero. Is there a way to remove the leading Zero in VBA. I ca
manually do this with the error checking wizard but I really need it t
do this within my code.

Example: 097894462 needs to be 97894462

ThXs,
Michae

--
Michael Wis
-----------------------------------------------------------------------
Michael Wise's Profile: http://www.excelforum.com/member.php...nfo&userid=699
View this thread: http://www.excelforum.com/showthread.php?threadid=38835