I am getting formula displayed in some cells rather than the resul

  • Thread starter Thread starter GG
  • Start date Start date
G

GG

For random individual cells within one worksheet. I can't find where you
tell at the individual cell level to display formula or result.

V. annoying.

Thanks in advance.
 
Try this,

Sounds like they may be formatted as TEXT
Select the offending cell and format as general.
Tap F2
Tap enter

Mike
 
Those cells were formatted as text before you entered the formula.
Just reformatting is not enough; format as General or Number AND re-enter the formula (F2, ENTER)

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| For random individual cells within one worksheet. I can't find where you
| tell at the individual cell level to display formula or result.
|
| V. annoying.
|
| Thanks in advance.
| --
| GG
 
Back
Top