formula does not display the resulting value in the cell

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Liliana - 18 Jul 2007 22:56 GMT

I have a correct formula, but instead of getting the result displayed, I get
the formula.

Reply to this Message

Peo Sjoblom - 18 Jul 2007 23:10 GMT

Change the format in the cell with the formula to either general or a
number, press F2 and enter

Signature

Regards,

Peo Sjoblom

>I have a correct formula, but instead of getting the result displayed, I
>get
> the formula.

Reply to this Message

Bob Phillips - 19 Jul 2007 08:50 GMT

Also check Tools>Options>View and make sure that the Formulas box is
unchecked.

Signature

HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

> Change the format in the cell with the formula to either general or a
> number, press F2 and enter
>
>>I have a correct formula, but instead of getting the result displayed, I
>>get
>> the formula.

Reply to this Message