Formula as Text

  • Thread starter Thread starter HALinNY
  • Start date Start date
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
 
hello Hal in NY,

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

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