ExcelBanter - formula showing in cell rather than answer for formula

ExcelBanter (https://www.excelbanter.com/)

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - formula showing in cell rather than answer for formula (https://www.excelbanter.com/new-users-excel/263299-formula-showing-cell-rather-than-answer-formula.html)

Debby

formula showing in cell rather than answer for formula

The formula showing in the cell rather than answer for formula.
I use Excel 2003.

Gord Dibben

formula showing in cell rather than answer for formula

Just one of many formulas is showing?

Re-format the cell from Text to General then F2 and Enter.

All formulas are showing?

Hit CTRL + `(backquote above Tab key to toggle out of formula view.

Gord Dibben MS Excel MVP

On Thu, 6 May 2010 13:35:01 -0700, Debby
wrote:

The formula showing in the cell rather than answer for formula.
I use Excel 2003.

All times are GMT +1. The time now is 02:32 AM.