formula displayed, not calculated
You probably have the cells formatted as text, so what might appear to
be =C1 is actually "=C1". You need to format the cells as general, and
then double-click (as if you are editting) or press F2 to get Excel to
recognise the new format.
Hope this helps.
Pete
Sander wrote:
Hi,
I'm working on a sheet with a couple of others and something happened in
such away that formulas I enter are not calculated but displayed as formulas.
So formulas allready there are calculated but new ones are not. I've tried
CTRL + `
but no luck with that.
I've the basis =C1 to point to the value C1 and let it show up. On some
sheets this works, on others it doesn't. Also on the sheet where this works,
I cannot get a value from another sheet.
Any ideas??
|