formula does not display the resulting value in the cell

L

Liliana

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

Peo Sjoblom

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

Bob Phillips

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

--
HTH

Bob

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy addition formula of non-consecutive horizontal cells 2
Newbie Help - IF Yes No Function 0
Drop down list control value in vba 2
Display weeks from a Milestone 0
MS Project. Real progress of the project, % complete 1
VB Script reference cells for in current table? 1
Convert Formula Results to Absolute 1
Cell reference in formula string displays abbreviated value 2

Top