formula displayed instead of value of formula

  • Thread starter Thread starter des-sa
  • Start date Start date
D

des-sa

when i type in a formula, say =QUOTES!A18, it is displayed as =QUOTES!A18
instead of the value of cell A18 in the sheet named QUOTES. what am i doing
wrong?
 
Select Tools/Options from Excel's menu bar, click the View tab on the dialog
box that appears and see if there is a check mark in the Formulas CheckBox
in the "Window options" section. If so, uncheck it.

Rick
 
was the cell formatted as text before the formula was entered. If so delete
it format as general and enter again

Mike
 
thanks so much, stupidity ruled!

Mike H said:
was the cell formatted as text before the formula was entered. If so delete
it format as general and enter again

Mike
Click to expand...
 
1. You are in "formula view". Hit CTRL + `(above Tab key)

2. The cell was pre-formatted as Text. Format to General then F2 and ENTER


Gord Dibben MS Excel MVP
 
Back
Top