Display Issue

[Going Crazy for Graphics]

When I enter a formula in a cell and hit enter, the cell then dispalys the
formula not the calculated value.
I can't seem to find the seting to change back and don't know what I did to
get to here

Thanks for any help

 

[Pete_UK]

The cell is probably formatted as text, so anything you enter is just
taken as a text string. With the cell selected click on Format | Cells
and then on the Number tab choose General then OK. This will not
change the format per se - you must change the cell's contents as
well. Double-click on the cell as if to edit it, then press <Enter>.

Hope this helps.

Pete

 

[Going Crazy for Graphics]

Pete: Thanks for the reply.
I have tried re-formatting with out success.
As I recall there is a setting in 07 that will display the formula or the
result, I just can't recall where it is and can't seem to find the tab its
located on

 

[Bob I]

Go to Office button, Excel Options, Advanced, Display options for worksheet.