View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
 
Posts: 8,651
Default Why it does not show formula?

I guess that your cell is formatted as text. Format it as General or
Number, and re-enter the formula.
--
David Biddulph

"Eric" wrote in message
...
When I type = sum(A1:A3) in cell A4, it shows statement as a text rather
than
a formula. Does anyone have any suggestions what cause this probelm?
Thanks in advance for any suggestions
Eric