Switching Between Showing Formula Or Actual Result In A Cell ?

  • Thread starter Thread starter Robert11
  • Start date Start date
R

Robert11

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


| 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
| > > >
| > > >
| > > >
 
Back
Top