Format Cell is Disabled?

[Sumless Mary]

Tray,

I have a similar problem with a worksheet I have been
using (part of a workbook I use every day). All the
formulas appear in the cells instead of the products
(answers)and formatting the cells again does nothing. I
have also posted a query to this group. We may be able
to use the same answers. I can get the formulas to work
when I copy my worksheet to a new one, although I wish to
fix the one in the workbook if I can. But, perhaps this
would work for you; just copy into a new one.

 

[Paul]

Try CTRL+`
That is, hold down CTRL whilst pressing the grave accent key, which on my UK
keyboard is above TAB and to the left of the number 1.
This toggles between viewing the formulas themselves and viewing the results
thereof.