G Guest Jul 18, 2007 #1 I have a correct formula, but instead of getting the result displayed, I get the formula.
P Peo Sjoblom Jul 18, 2007 #2 Change the format in the cell with the formula to either general or a number, press F2 and enter
B Bob Phillips Jul 19, 2007 #3 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)
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)
