How to get value out of formulae

[Kozmo]

I'm having problems with formulae.

I type a formula into a cell and I get the formula; I can't get the value.
When I copy a cell with a formula, the value is copied not the relative
formula. Frustrating.

This hasn't happened to me before until I moved the spreadsheet to a machine
using another version of Excel 2000.

sometimes I get it to work with a combination of format changes of the
reference cells and the formula cell but I can't fix it consistently.

Any ideas?

Kozmo

 

[Peo Sjoblom]

First check under tools>options>calculations and see if you have manual
calculation, if so set it to automatic.
If that does not work try to trigger calculations by doing a edit>replace
and replace the equal sign by the equal sign =

 

[Kozmo]

Nope. I'm on auto calc and editing the = to = doesn't change things.

thanks
Kozmo

 

[Peo Sjoblom]

How about ctrl + ` (grave accent), still the same?