# Vba To Remove Zeros

Nov 6, 2007i have numbers like:

00012334

00122434

00000344

00003432

i need:

12334

122434

344

3432

i cant use formulas because its in text and for some reason if i try to use a formula the formula shows but not the answer.

vba would be prefered.