Hi Elkar,

I spoke too soon. It worked briefly and then converted back to the formula
again. The cell doesn't seem to want to stay formatted as general. It
switched back to text. I think that is why it doesn't calculate the formula.

Any ideas?

Paul

"Elkar" wrote:

There are a couple reasons why this might be happening.

Make sure "Display Formulas" is turned off:
Go to TOOLS, then OPTIONS, then VIEW Tab
Make sure "Formulas" is not checked

Make sure the cell you're entering the formula into is not formatted as Text:
Select the cell
From the Format Menu, choose "Cells..."
On the Number Tab, choose "General" as your category
Click OK
Re-enter the formula (you can just hit F2 then Enter.

HTH,
Elkar


"Paul" wrote:

When I type a formula in my spreadsheet it appears as the text of the formula
but not as the calculated value. Can anyone help?