Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 | | | |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using an offset formula for the reference in a relative reference | Excel Worksheet Functions | |||
Reusing formula | Excel Discussion (Misc queries) | |||
Formula Showing In A Cell Instead of Proper Result | New Users to Excel | |||
Formula displays result in formula box but not in cell | Excel Discussion (Misc queries) | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions |