Argh, I did not know that. And I am using 2000. Thanks.
--
Kevin Vaughn


"Peo Sjoblom" wrote:

In pre 2002 versions if you copy the formula to another sheet it will crash
brutally and you will lose all work

--
Regards,

Peo Sjoblom

Portland, Oregon




"Kevin Vaughn" wrote in message
...
Regarding my previous post, I wonder if that is the old XLM trick to which
Peo is referring.
--
Kevin Vaughn


"tina" wrote:

May I know what is wrong over here?

I have a formula in A1 cell (eq. 3+5 formatted as text) and try to let B1
have the result of A1. so I set B1 =Value(A1)...it doesn't work but it
will
work if I put =value(3+5)...
Is there anyone can tell me what is wrong here?