Eliminate leading numbers - Excel 2007
 

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.

Eliminate leading numbers - Excel 2007
 

Try this:

=Right(A1,6)
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"David Lee Stewart" wrote in
message ...
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.

Eliminate leading numbers - Excel 2007
 

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

"David Lee Stewart" wrote:

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.