Formula

C

Charles

Hello,

When ever I type a formula in a cell (For Ex: =sum(A63:A77)), I see the
formula in the cell. I am not able to see the value (result) of the formula.
I am not sure what setting was changed and how it was changed.

Can you please let me know how to revert the settings so that I can see the
resultant value of a formula in the cell?

Thanks and Regards,
Charles
 
G

Gary''s Student

1. clear the cell
2. Format > Cells... > Number > General
3. retype the formula (DON'T PASTE IT FROM ELSEWHERE)

Your problem is probably that the format is Text.

Good Luck
 
C

Charles

Not helping. Still see the same issue. It happens in any datatype.

Actually it happens for any formula. For ex: =CONCATENATE(A1, ".", B1, ".",
C1)
 
T

tjtjjtjt

If the cells aren't formatted as text, perhaps you are showing the formulas.
Press Ctrl+` (the button usually beneath Esc).
-or-
Tools | Options | View. Look under the Window options heading for Formulas.
If it is checked, uncheck it.
 
C

Charles

Cntrl + ' just changes the width of the column. :(

Tools->Options->View-Window Options->Formula is unchecked. Toggling this
value adjusts the width of the column.

Still no luck. :(
 
D

Dave Peterson

Actually, ctrl-backquote toggles the formula view.

Try formatting the offending cells as General
then reenter the formula (F2 followed by enter is enough)

If you have lots of cells, you could even
edit|Replace
what: = (equal sign)
with: = (equal sign)
replace all

(It's not enough just to change the format--you have to reenter the formula,
too.)
 
Top