Formulae not displaying

[Brian Tozer]

I have a worksheet where none of the formula on the page will display as
formula.
For example I have columns of cells formatted as currency thus having a
leading dollar character.
When I enter Control Grave all of these, both data and formulae, display as
a numeric without the dollar symbol.
The cells with formula display the data product, not the formula.
I also have a date cell formatted the same as the other dates in the column,
and displaying the same until I hit Control Grave, whereapon that date is
displayed still in date format and all the other dates in the same column
display as a single numeric.

I do not know what to do to fix the problem, or what is causing it.
Can anyone help?
TIA
Brian Tozer

 

[Dave Peterson]

Does tools|options|view|formulas worked ok?

Jim Rech replied to your other post asking if it was just happened in one
workbook or in all.

And if you open excel in Safe mode, does it happen then, too.

Close excel
windows start button|run
excel /safe
open your workbook

Test it out.

=====
And this doesn't sound like a fit, but when I format a cell:
format|cells|protection tab
and lock it
and check that hidden box

Then after I protect the sheet (tools|Protection|protect sheet), I can't see any
of the formulas (or values) for those locked & hidden cells.

=====
And you may want to double check those date cells that still show as dates.
Maybe they're really text.

Format the cell as general and then reenter the date to see if that helps.
(It's a two part process.)

 

[Brian Tozer]

Dave Peterson wrote:

Thanks very much for your comprehensive response Dave.
You have given me a lot to look into, but of even more value have let me
know that there is not some common cause.

Brian Tozer