cell formatting shows the formula not the value
 

Hi all,
Hope someone can help with this. I some how have forgotten how to correctly
format a cell when the formula that is typed in shows vs the value.
IE =sum(Range) shows instead of the actual sum

Thanks for the reminder!
CRS is an ugly thing when it happens to the ones you love!! :) Give
generously to the CRS foundation!

Greg

--
Have a great day and a better tomorrow!

cell formatting shows the formula not the value
 

Either of two problems.

1. You have formula view enabled.

Hit CTRL + ' to toggle off/on.

2. The cell(s)column was pre-formatted as text.

Change format to General then F2 and ENTER on the cells.

If you have a great whack of these to do, EditReplace

what: =

with: =

Replace all.


Gord Dibben MS Excel MVP

On Tue, 5 Dec 2006 09:56:00 -0800, gjmink
wrote:

Hi all,
Hope someone can help with this. I some how have forgotten how to correctly
format a cell when the formula that is typed in shows vs the value.
IE =sum(Range) shows instead of the actual sum

Thanks for the reminder!
CRS is an ugly thing when it happens to the ones you love!! :) Give
generously to the CRS foundation!

Greg

Gord Dibben MS Excel MVP

cell formatting shows the formula not the value
 

Hi Greg

It sounds as though the cell has been pre-formatted as text
Change the cell format FormatCellsNumberGeneral and press F2 to edit
the formula and press Enter.

Alternatively, you may have the toggle set to display formulae, rather
than their results.
Try pressing CTRL + ` (that's Control plus the grave accent, usually
found on the key above the Tab key)
This is a toggle, and pressing it alternately will switch between
formula view and results view.

--
Regards

Roger Govier


"gjmink" wrote in message
...
Hi all,
Hope someone can help with this. I some how have forgotten how to
correctly
format a cell when the formula that is typed in shows vs the value.
IE =sum(Range) shows instead of the actual sum

Thanks for the reminder!
CRS is an ugly thing when it happens to the ones you love!! :) Give
generously to the CRS foundation!

Greg

--
Have a great day and a better tomorrow!