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

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

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

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

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

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

Charles wrote:

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


--

Dave Peterson