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

"GG" wrote in message ...
| 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