calculate using last four digits of number in cell

[Andy Falkner]

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.

 

[Bob Phillips]

=--right(a1,4)

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

 

[Don Guillett]

try
=RIGHT(E4,4)*2

 

[Bernard Liengme]

How about an example?