=--right(a1,4)

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"Andy Falkner" <Andy wrote in message
...
I need a formula that will calculate the last four digits of a number in a
series of cells. The first five numbers are the same.