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?