View Single Post
  #4   Report Post  
David Billigmeier
 
Posts: n/a
Default

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