View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
John[_22_] John[_22_] is offline
external usenet poster
 
Posts: 694
Default Problem with a simple formula

Hi
The cell is formatted as text, clear the cell and reformat as general, now your
formula will work.
HTH
John
"ChristiW26" wrote in message
...
I've entered a simple "=sum" formula into a cell on a worksheet and for some
reason, the formula is being displayed in the cell instead of the value.
I've used this formula countless times before and have never had this happen.
I've checked everything I know to check and I'm just at a loss. Anyone have
any advice?

Thanks,
Christi