Dropping leading zeros off a column of numbers
Posted by Kellie on September 25, 2001 6:19 PM
I need a way to drop off the leading zeros in a column
of numbers. Example: 00101
00035
05006
Etc...
I want the numbers to be 101, 35, and 5006.
Any easy solutions?
Posted by Jackie on September 25, 2001 6:27 PM
Put 1 in a blank cell
Copy
Select the cells you want to drop leading zero
PasteSpecial>Multiply
