How to get value out of formulae

  • Thread starter Thread starter Kozmo
  • Start date Start date
K

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
 
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 =
 
Back
Top