Thread: formula displayed instead of value of formula
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Rick Rothstein \(MVP - VB\)[_730_] Rick Rothstein \(MVP - VB\)[_730_] is offline
external usenet poster
  
Posts: 1
Default formula displayed instead of value of formula
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


"des-sa" wrote in message
...
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?

Reply With QuoteReply With Quote