formula rather than result displayed

J

John Keith

I am adding formulas to a spreadsheet that was downloaded from another
program (each cell appears to be a text formatted cell) but rather
than the formula result being displayed the formula is being
displayed. I've done the CTL+~ and also the Tools|Options|View methods
of trying to switch between displaying formulas and results but always
the formula is being displayed. I assume there is something set on
this downloaded spreadsheet that is controlling this behavior but I
don't have a clue on what it is. Can anyone suggest how reset this
mode?


John Keith
[email protected]
 
P

Peo Sjoblom

Try this, first select the range with the formulas, then make sure the
format is general, once that has been done do

Ctrl + H, replace = with =

replace equal sign with equal sign, that usually forces calculation
 
J

John Keith

Thank you Bob and Peo.

Each of your solutions worked! Bob's solution was a little more
permanent, using Peo's technique I had to reapply it every time I
modified teh formula.

John Keith
[email protected]
 
Top