Formulas displayed in all of my cells

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

electric utility engineer - 19 Mar 2008 12:22 GMT

I had a completed worksheet that was working properly. Somehow, the sheet
was changed so that every cell displays the formula instead of the result.
Date cells display the absolute date number. I don't know how it happened,
and I don't know how to get it back. I can not simply reformat the cell, and
I don't see any sheet formatting functions or view functions that would
globally fix.

Reply to this Message

Ron Coderre - 19 Mar 2008 12:27 GMT

Try this:

From the Excel Main Menu:
<tools><options><view>...UNcheck: Formulas

or...the shortcut....
Ctrl+~..........That's: Hold down the Ctrl key and press ~

Does that help?
Post back if you have more questions.
--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)

>I had a completed worksheet that was working properly. Somehow, the sheet
> was changed so that every cell displays the formula instead of the result.
[quoted text clipped - 4 lines]
> I don't see any sheet formatting functions or view functions that would
> globally fix.

Reply to this Message

electric utility engineer - 19 Mar 2008 19:55 GMT

Thanks very much. I did it both ways. The short cut was especially helpful
because it explained how I did it. I was leaning over the left side of my
keyboard to unplug the power cord from the back of the docking station, and I
must have hit the two shortcut keys. Thanks for taking the time to help me.

> Try this:
>
[quoted text clipped - 22 lines]
> > I don't see any sheet formatting functions or view functions that would
> > globally fix.

Reply to this Message

Ron Coderre - 19 Mar 2008 19:56 GMT

You're very welcome.....I'm glad I could help.

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)

> Thanks very much. I did it both ways. The short cut was especially
> helpful
[quoted text clipped - 33 lines]
>> > I don't see any sheet formatting functions or view functions that would
>> > globally fix.

Reply to this Message

Stefi - 19 Mar 2008 12:31 GMT

Tools>Options>Display tag>Uncheck Formulae checkbox
Regards,
Stefi

„electric utility engineer” ezt írta:

> I had a completed worksheet that was working properly. Somehow, the sheet
> was changed so that every cell displays the formula instead of the result.
> Date cells display the absolute date number. I don't know how it happened,
> and I don't know how to get it back. I can not simply reformat the cell, and
> I don't see any sheet formatting functions or view functions that would
> globally fix.

Reply to this Message

electric utility engineer - 19 Mar 2008 19:51 GMT

Thanks so much. What a relief. It is also embarassing that it was so
simple, and I didn't find it. Thank you.

> Tools>Options>Display tag>Uncheck Formulae checkbox
> Regards,
[quoted text clipped - 8 lines]
> > I don't see any sheet formatting functions or view functions that would
> > globally fix.

Reply to this Message