Delete leading zeros
 

Could someone please help me. I have forgotten how to delete the zeros
infront of numbers.
I havea column of numbers.
ie:
0015L
000043
I want to delete all the zeros on the left of the number.
Thanks,
Joe

See my reply under "Serial Number List". Use Data/Text to columns. Wizard is
fairly explicit.

Roger


"lunker55" wrote:

Could someone please help me. I have forgotten how to delete the zeros
infront of numbers.
I havea column of numbers.
ie:
0015L
000043
I want to delete all the zeros on the left of the number.
Thanks,
Joe

Copy an empty cell, Select the range of numbers you have, and Paste
Special-Add

--
Regards,
Dave
<!--


"lunker55" wrote:

Could someone please help me. I have forgotten how to delete the zeros
infront of numbers.
I havea column of numbers.
ie:
0015L
000043
I want to delete all the zeros on the left of the number.
Thanks,
Joe

Roger,
That won't work because I have a different number of zeros in each cell.

Joe

"RogerN" wrote in message
...
See my reply under "Serial Number List". Use Data/Text to columns. Wizard
is
fairly explicit.

Roger


"lunker55" wrote:

Could someone please help me. I have forgotten how to delete the zeros
infront of numbers.
I havea column of numbers.
ie:
0015L
000043
I want to delete all the zeros on the left of the number.
Thanks,
Joe

Dave

I would have suggested the formula =value() in next available column, as
Excel would then strip the leading zeros but I do like your solution . Very
neat, thanks.

Roger

"David Billigmeier" wrote:

Copy an empty cell, Select the range of numbers you have, and Paste
Special-Add

--
Regards,
Dave
<!--


"lunker55" wrote:

Could someone please help me. I have forgotten how to delete the zeros
infront of numbers.
I havea column of numbers.
ie:
0015L
000043
I want to delete all the zeros on the left of the number.
Thanks,
Joe