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)

"electric utility engineer" <electric utility
wrote in message
...
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.