Formula as Text

H

HALinNY

This is driving me batty. I entered a formula and it is being treate
as text. The expression is not evaluated. Doesn't matter what th
formula is, even =A1 goes in as text. If I press F2 and the F9 th
formula is evaluated and the result replaces the original entry.

Help! Please!

HALinN
 
F

firefytr

hello Hal in NY,

check Tools -> Options -> Calculate, is set to Autocalculate. this ma
be your problem.

ht
 
G

Gord Dibben

Hal

Either you have View Formulas checked in Tools>Options>View or
the cells are pre-formatted as text.

Hit CRTL + `(above TAB key) to toggle Formula View on/off, if that is the
case.

If text cells, select the cells and Format as General then re-enter by
selecting a cell and hitting F2 then <ENTER>.

For a bunch of formulas a quick way to re-enter them is to select the cells
then Edit>Replace

what: =
with: =

Replace all.

Gord Dibben Excel MVP
 
H

HALinNY

Thanks to Gord for figuring this out. The cell was formatted as text
and the fix for that case worked. Problem solved, knowledge gained.
Thanks
 
Top