AFAIK you can't
if you type over the top of a value it goes
if you need to keep a record of previous values then this is generally done
via the use of columns with dates on them

sorry i can't be of more help
Cheers
JulieD



"Goody" wrote in message
...
NO, I mean that if a cell's (A1 for example) value was 1 one week, and
then
A1 is 2 this week, how do I get excel to display the previous value in A1?

"JulieD" wrote:

Hi

not sure what you mean by a previous cell's value

do you mean in A2 you want the value that is in A1?
if so the formula
=A1
in A2 will give it to you

Cheers
JulieD


"Goody" wrote in message
...
I run a fantasy racing league with some friends. I am trying to find
out
how
to return a previous cell's value, such as a player's rank from last
week.
I
am doing it manually now, but there has to be a better way. Thanks!