Eliminate leading numbers - Excel 2007

  • Thread starter Thread starter David Lee Stewart
  • Start date Start date
D

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.
 
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
 
Back
Top