Worksheet Functions
 

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?

Worksheet Functions
 

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


"Denrae" wrote in message
...
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?

Worksheet Functions
 

Hi,

Ensure that the cell is not formatted as a text value

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Denrae" wrote in message
...
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?

Worksheet Functions
 

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

"Ashish Mathur" wrote:

Hi,

Ensure that the cell is not formatted as a text value

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Denrae" wrote in message
...
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?

Worksheet Functions
 

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

"Denrae" wrote in message
...
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

"Ashish Mathur" wrote:

Hi,

Ensure that the cell is not formatted as a text value

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Denrae" wrote in message
...
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?

Worksheet Functions
 

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

EditReplace

What: =

With: =

Replace all

This saves all those F2Enters


Gord Dibben MS Excel MVP

On Wed, 5 May 2010 22:00:39 -0600, "Fred Smith" wrote:

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

"Denrae" wrote in message
...
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

"Ashish Mathur" wrote:

Hi,

Ensure that the cell is not formatted as a text value

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Denrae" wrote in message
...
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?