Formula showing in cell
in [General]
|
Prev: Deleting rows meeting certain criteria in a particular column
Next: Formula showing in cell -- Never mind
From: Carolyn on 1 Apr 2010 14:53 When I type a formula in a cell after hitting enter, the forumla not the value appears in the cell. It is not toggled to show the formula nor are the existing formulas in other cells showing. Any ideas? Carolyn
From: Gord Dibben on 1 Apr 2010 15:12 Cell format is most likely Text. Re-format the cell to General then F2 and ENTER to re-enter the formula. Gord Dibben MS Excel MVP On Thu, 1 Apr 2010 11:53:06 -0700, Carolyn <Carolyn(a)discussions.microsoft.com> wrote: >When I type a formula in a cell after hitting enter, the forumla not the >value appears in the cell. It is not toggled to show the formula nor are the >existing formulas in other cells showing. > >Any ideas? > >Carolyn
From: Luke M on 1 Apr 2010 15:57
Format the cell to something other than text, re-enter the formula. -- Best Regards, Luke M "Carolyn" <Carolyn(a)discussions.microsoft.com> wrote in message news:33CF371C-3F96-4026-AEEE-E48D21B7B052(a)microsoft.com... > When I type a formula in a cell after hitting enter, the forumla not the > value appears in the cell. It is not toggled to show the formula nor are > the > existing formulas in other cells showing. > > Any ideas? > > Carolyn |