View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
 
Posts: 8,651
Default some cells display formulas, some display values

You'd probably formatted the cells as text before you entered the formula.
Format as General or Number, and re-enter the formula.
--
David Biddulph

"mvivelo" wrote in message
...
In the same worksheet at the same time, I have some cells that properly
display formula values, but others will only display the formula. It is
as
if Excel does not recognize =8+8 as a formula in some cells, but does in
others. CNTRL+` does not work. Is it a format issue, or some setting?