deleting numbers in a column

[roddtx]

can someone assist with the formula that would allow me to remove
all but the last 4 digits in a column of numbers

 

[Guest]

Hi
You could use a helper column with this in:
=RIGHT(A2,4)
and fill this down.

Andy.

 

[Bernard Liengme]

Can we assume we are dealing with whole numbers?
=--RIGHT(A1,4)
RIGHT returns text, the double negation turns this back to a number

OR

=MOD(A1,10000)

Then copy either formula down the column.

 

[roddtx]

you are the best

> Hi

You could use a helper column with this in:
=RIGHT(A2,4)
and fill this down.

Andy.

"roddtx" <[email protected]> wrot
in
message news:[email protected]...
http://www.excelforum.com/showthread.php?threadid=523694