Excel formulas become cell contents

  • Thread starter Thread starter DJLT
  • Start date Start date
D

DJLT

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.
 
DJLT said:
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.
Click to expand...

The cell is formatted as TEXT. Change the cell format to GENERAL and re-enter
the formula.
 
DJLT said:
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.
Click to expand...

The cell is formatted as TEXT. Change the cell format to GENERAL and re-enter
the formula.
 
Select the range where you have the proble. Right click>Format Cells>change
that to General..ok.
 
Select the range where you have the proble. Right click>Format Cells>change
that to General..ok.
 
Back
Top