Cell doesn't show formula result - it shows formula (CTRL + ' doe.

[o0o0o0o]

Cell doesn't show formula result - it shows formula (CTRL + ' doesn't change
it), looks like it happens only when formula is entered manually. If I copy
and paste cell with formula - works fine, if I change the cell location
whitin formula (i.e. =Schedule!F6 change to =Schedule!H6) - it won't show
result, just the formula. I have Office XP, Win XP pro SP2 (all updated), and
I also tried reinstalling Office - worked fine for a while and then started
doing the same thing.
Any help would be greatly appreciated

 

[Guest]

check the cell format and make sure it is not formated as
text.

 

[Kyli]

I end up with that all the time! The best thing to do is format the
column/row/cell as "General".

 

[oo00oo]

Already tried

check the cell format and make sure it is not formated as
text.

 

[Gord Dibben]

Changing the format from text to general is not sufficient.

You must now re-enter the formula(s)

F2 then <ENTER>

If you have great many of these, do an Edit>Replace

What: =
With: =

Replace all.

Gord Dibben Excel MVP

 

[oo00oo]

Tried that also, but I just restarted computer and it works fine (even though
i also tried this several times).
Thanks for your time, i'll just wait and see what happens next.

 

[dc]

Your advice works, thank you very much.

I end up with that all the time! The best thing to do is format the
column/row/cell as "General".