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. :(

"tjtjjtjt" wrote:

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.
--
tj


"Charles" wrote:

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

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

"Gary''s Student" wrote:

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
--
Gary''s Student


"Charles" wrote:

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