Worksheet Functions

[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?

 

[David Biddulph]

I assume that your cell is formatted as text. Format the cell as General
(or Number) and re-enter the formula.

 

[Ashish Mathur]

Hi,

Ensure that the cell is not formatted as a text value

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

 

[Denrae]

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

 

[Fred Smith]

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

 

[Gord Dibben]

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