Eliminate leading numbers - Excel 2007

[David Lee Stewart]

I have a column with numbers that range from 00000025 to 00985765. I want to
show only the last six digits and delete the two leading zeros. The cells
are currently formated as text. I want leading zeros if they are within the
last six digits. Since there are 14,000 cells in the column, I am looking
for a way to format the appearance without doing individual cells. Thank you.

 

[RagDyer]

Try this:

=Right(A1,6)

 

[cvgairport]

Try using an =mid formula. If the number - 00000025 - is in cell A1, then in
cell B1 type =MID(A1,3,6). That should return 000025. You could insert a
column next to your 14000 numbers and copy this formula down.

Hope this helps.

Amy