Worksheet Functions

  • Thread starter Thread starter Denrae
  • Start date Start date
D

Denrae

No matter how I enter a function, it displays as text in the cell and doesn't
perform the calculation. How can I enter a simple formula and have it display
the result?
 
Thanks Ashish and David,

I found I had to delete my formulae, reformat the column as General, and
then re-enter the formula before it worked. Problem solved. Neil
 
And, you don't have to delete the formula first. Just reformat, hit F2 and
enter.

In future, make your life easier by ensuring the cells aren't formatted as
text to begin with.

Regards,
Fred
 
And if you have enterd many formulas do an edit/replace after re-formatting
to General.

Edit>Replace

What: =

With: =

Replace all

This saves all those F2>Enters


Gord Dibben MS Excel MVP
 
Back
Top