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
|