View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Glenn Glenn is offline
external usenet poster
 
Posts: 1,240
Default Excel formulas become cell contents

DJLT wrote:
I am experiencing a problem in Excel. When I enter a formula (any formula)
in certain cells the formula remains visible in the cell as the cell content.
However if I enter the same formula in another part of the spreadsheet the
formula behaves the way it is suppose to...invisible except for the results
of the formula.


The cell is formatted as TEXT. Change the cell format to GENERAL and re-enter
the formula.