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)

"Andy Falkner" <Andy [email protected]> wrote in message
news:[email protected]...
> 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.

[Don Guillett]

try
=RIGHT(E4,4)*2

--
Don Guillett
SalesAid Software
[email protected]
"Andy Falkner" <Andy [email protected]> wrote in message
news:[email protected]...
>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.

[Bernard Liengme]

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

"Andy Falkner" <Andy [email protected]> wrote in message
news:[email protected]...
>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.