MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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