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

Andy.

"roddtx" wrote in
message ...

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


--
roddtx
------------------------------------------------------------------------
roddtx's Profile:
http://www.excelforum.com/member.php...o&userid=32571
View this thread: http://www.excelforum.com/showthread...hreadid=523694