Switching Between Showing Formula Or Actual Result In A Cell ?
 

Hello:

Probably so simple, I'm embarrased to ask.

I put in a formula such that in a cell there would be the SUM of a column of
numbers.
Pretty sure I did it correctly.

When i look at the cell that should have the Sum, I see the formula.

How do I switch between this cell showing the formular and/or the Sum ?

Thanks,
Bob

Switching Between Showing Formula Or Actual Result In A Cell ?
 

you may have missed the = sign from in front of your formula

"Robert11" wrote:

Hello:

Probably so simple, I'm embarrased to ask.

I put in a formula such that in a cell there would be the SUM of a column of
numbers.
Pretty sure I did it correctly.

When i look at the cell that should have the Sum, I see the formula.

How do I switch between this cell showing the formular and/or the Sum ?

Thanks,
Bob

Switching Between Showing Formula Or Actual Result In A Cell ?
 

CNTRL~ will toggle between formula display and results display.
--
Gary's Student


"Mike" wrote:

you may have missed the = sign from in front of your formula

"Robert11" wrote:

Hello:

Probably so simple, I'm embarrased to ask.

I put in a formula such that in a cell there would be the SUM of a column of
numbers.
Pretty sure I did it correctly.

When i look at the cell that should have the Sum, I see the formula.

How do I switch between this cell showing the formular and/or the Sum ?

Thanks,
Bob

Switching Between Showing Formula Or Actual Result In A Cell ?
 

or CNTRL + `

"Gary''s Student" wrote:

CNTRL~ will toggle between formula display and results display.
--
Gary's Student


"Mike" wrote:

you may have missed the = sign from in front of your formula

"Robert11" wrote:

Hello:

Probably so simple, I'm embarrased to ask.

I put in a formula such that in a cell there would be the SUM of a column of
numbers.
Pretty sure I did it correctly.

When i look at the cell that should have the Sum, I see the formula.

How do I switch between this cell showing the formular and/or the Sum ?

Thanks,
Bob

Switching Between Showing Formula Or Actual Result In A Cell ?
 

But it might also be that the cell was formatted as TEXT before you entered the formula. Just formatting to something else doesn't
help; format as General or Number AND re-enter the formula (F2, ENTER)

--
Kind regards,

Niek Otten
Microsoft MVP - Excel


"Mike" wrote in message ...
| or CNTRL + `
|
| "Gary''s Student" wrote:
|
| CNTRL~ will toggle between formula display and results display.
| --
| Gary's Student
|
|
| "Mike" wrote:
|
| you may have missed the = sign from in front of your formula
|
| "Robert11" wrote:
|
| Hello:
|
| Probably so simple, I'm embarrased to ask.
|
| I put in a formula such that in a cell there would be the SUM of a column of
| numbers.
| Pretty sure I did it correctly.
|
| When i look at the cell that should have the Sum, I see the formula.
|
| How do I switch between this cell showing the formular and/or the Sum ?
|
| Thanks,
| Bob
|
|
|