How do I remove preceding zeros from a number like 00958?

format the cell as number

put a 1 in another cell.  Copy that cell

then select the cell with 00948 and do a paste special and in the paste special dialog, choose multiply  (the paste special option is found in the paste dropdown on the Home tab.

You can do this to multiple cells all at once if they have leading zeros.

--

Regards,

Tom Ogilvy

Trying to do a lookup code and the comparable cell in the named table is a number, format General  (looks like 958).  The column of numbers to compare with are also formatted as General, but are preceded by a zero that I would like to remove (i.e. 00958).  Thank you.

Hi,

Cells might in Text fomat, click on it then press F2, delete the ' before the zeros. if you have a long list, put this beside it (B1), assumming A is the column of your numbers...

=VALUE(A1)

Copy B1 and paste downward...

Addtional: Copy the range formula with the results, then paste-special/values into the original location.

Hope it helps,

Jaeson