Well, do you want to keep the part numbers as text, or do you want to convert
them to numbers?

If text, insert a blank column next to the part numbers and (assuming the
part numbers are in column B), use this formula to strip off the first
character of the cell

=RIGHT(B1,LEN(B1)-1)

if you want the part numbers as numbers,
1) format the column as numbers
2) then enter a '1' in an empty cell and copy it
3) select the part numbers and from the menu choose Edit | Paste Special |
Multiply | Values


"sharonkturner" wrote:

I have a rather large (thousands) db of part numbers that have an extra
leading zero. Is there a simple way to make the correction?