Eliminating digits

[Guest]

I am trying to print a list of customer numbers and they are in a six digit
format. I only want the last four digits printed. The first two numbers are
just "00" How do I elimiate those first two numbers? Is it a certain type of
formatting?

 

[CLR]

Try this...........enter 1 in an unused cell, then click on it and do Copy

then highlight the cells you wish to change and do PasteSpecial >

Multiply.........

OR, in the next column enter =RIGHT(A1,4) to leave the result formatted as
TEXT or =RIGHT(A1,4)*1 to change it to numbers..........

Vaya con Dios,
Chuck, CABGx3

 

[Richard Neville]

If you try to eliminate the initial 00's with the Replace function, you
could mess up a number like 1200, which this would change to 12. Instead, I
would change the number format. In Format-Cells, select the Number tab and
click on Custom. In the box to the right type ###0 and this will change an
entry like 002345 to 2345.

 

[Gord Dibben]

If they are not Formatted as Custom 000000 then they are probably text.

In that case, follow Chuck's method of changing them to real numbers.


Gord Dibben Excel MVP