Check your options and make sure 'display formulas in cell' is not checked.
--
Brevity is the soul of wit.


"Papa Jonah" wrote:

I have entered a formula in a cell (B76) which reads:
=left(A76,18)
There is not a ' before the =, so I do not know why the cell displays
"=left(A76,18)" instead of "Facilities & Infra"
Protection is turned of for the worksheet and the cell.

Any ideas why?

TIA
Papa