View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
des-sa[_2_] des-sa[_2_] is offline
external usenet poster
 
Posts: 74
Default formula displayed instead of value of formula

thanks so much, stupidity ruled!

"Mike H" wrote:


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

Mike

"des-sa" wrote:

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?