Eliminating digits

S

SeanM

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?
 
C

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 >
Click to expand...
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
 
R

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.
 
G

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
 
Top