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
|