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

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

On Jan 28, 4:46*pm, Going Crazy for Graphics
wrote:
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: 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

"Pete_UK" wrote:

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

On Jan 28, 4:46 pm, Going Crazy for Graphics
wrote:
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

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

Going Crazy for Graphics wrote:
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

"Pete_UK" wrote:


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

On Jan 28, 4:46 pm, Going Crazy for Graphics
wrote:

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