How about an example?
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

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