Deleting Lead Zeros

[Guest]

Hi All,

Is there a function in Excel that allows the lead zeros to be removed. The
first number in the list has 3 zeros and the final 2 zeros. What would be
the best method to remove?

00076245
00076273
00224278
00258071
00250746

I'd appreciate any assistance the group can offer.

TIA - H

 

[Guest]

Hi Hardip,

Formatting the column as Number removes leading zeros.
If you want to keep the column as text, select the column, choose replace,
write 0 in to be replaced, write "" (empty string) in replaced by, and select
replace all!

Regards,
Stefi


„Hardip†ezt írta:

 

[Guest]

Sorry, the second case is wrong, because it will replace all zeros not only
the leading ones.
Instead: supposed the cell to be converted is A2, use a helper column with
the function =text(value(A2),"@")


Regards,
Stefi

„Hardip†ezt írta:

 

[Krishnakumar]

Hi,

Try,

=VALUE(A1)

HTH

 

[Guest]

Thanks for replying people.

I tried all the examples and found Krishna's example worked. However,
thanks to all who replied.

Best - H