Hi
maybe in B2 the following formula
=A2/A1-1
and format as percentage and copy down for the whole row

--
Regards
Frank Kabel
Frankfurt, Germany


JIM wrote:
I have about 1000 numbers that represent the monthly
closes of a stock. Is there a way in excel to make a
formula that would show in the next column the gain or
loss by dividing one number by the previous?

JIM