Display Issue

  • Thread starter Going Crazy for Graphics
  • Start date
G

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
 
P

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
 
G

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
 
Top