Deleting Lead Zeros
 

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

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:

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

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:

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

Hi,

Try,

=VALUE(A1)

HTH


--
Krishnakumar


------------------------------------------------------------------------
Krishnakumar's Profile: http://www.excelforum.com/member.php...o&userid=20138
View this thread: http://www.excelforum.com/showthread...hreadid=400738

Thanks for replying people.

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

Best - H

"Krishnakumar" wrote:


Hi,

Try,

=VALUE(A1)

HTH


--
Krishnakumar


------------------------------------------------------------------------
Krishnakumar's Profile: http://www.excelforum.com/member.php...o&userid=20138
View this thread: http://www.excelforum.com/showthread...hreadid=400738