Formula stays in the cell

The formula result does not display in the cell, instead the formula itself
displays in the cell. I have tried different formats but continue to have
the same problems.

Hi Mindie

two possible problems
first check tools / options / view and ensure that formulas is not ticked
second it is possible that the cell has been formatted to text - select a
cell from a new sheet and choose copy, now select your formulas and choose
edit / paste special - Add ... you then might need to choose edit / replace
and type a = in both the find and replace lines and do a replace all.

hope this helps
Cheers
JulieD

"Mindie" <Mindie@discussions.microsoft.com> wrote in message
news:AB6A5082-8617-421F-8AE5-13AB58B3A006@microsoft.com...
> The formula result does not display in the cell, instead the formula
> itself
> displays in the cell. I have tried different formats but continue to have
> the same problems.

Sounds like Excel is set to display formulas.

Press Ctrl+`
That's the button directly below the Esc Key on most keyboards.

tj

"Mindie" wrote:

> The formula result does not display in the cell, instead the formula itself
> displays in the cell. I have tried different formats but continue to have
> the same problems.

Look at:
<Tools> <Options> <View> tab,
And make sure that "Formulas" is *UNchecked*.

If it already is unchecked, try this:

Select the cell with the "bad " formula, then:
<Ctrl> <Shift> <~>
Then,
<F2>
Then
<Enter>

What you did here was format the cell to "General", then re-entered it.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"Mindie" <Mindie@discussions.microsoft.com> wrote in message
news:AB6A5082-8617-421F-8AE5-13AB58B3A006@microsoft.com...
The formula result does not display in the cell, instead the formula itself
displays in the cell. I have tried different formats but continue to have
the same problems.

Thanks, that did the trick!

"RagDyeR" wrote:

> Look at:
> <Tools> <Options> <View> tab,
> And make sure that "Formulas" is *UNchecked*.
>
> If it already is unchecked, try this:
>
> Select the cell with the "bad " formula, then:
> <Ctrl> <Shift> <~>
> Then,
> <F2>
> Then
> <Enter>
>
> What you did here was format the cell to "General", then re-entered it.
> --
>
> HTH,
>
> RD
> ==============================================
> Please keep all correspondence within the Group, so all may benefit!
> ==============================================
>
>
> "Mindie" <Mindie@discussions.microsoft.com> wrote in message
> news:AB6A5082-8617-421F-8AE5-13AB58B3A006@microsoft.com...
> The formula result does not display in the cell, instead the formula itself
> displays in the cell. I have tried different formats but continue to have
> the same problems.
>
>
>

Thanks for the feed-back ... BUT ... out of curiosity,
Which one "did the trick" ?
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Mindie" <Mindie@discussions.microsoft.com> wrote in message
news:FF306B23-DB23-4E78-A8F5-BA7DA23D1E54@microsoft.com...
> Thanks, that did the trick!
>
> "RagDyeR" wrote:
>
> > Look at:
> > <Tools> <Options> <View> tab,
> > And make sure that "Formulas" is *UNchecked*.
> >
> > If it already is unchecked, try this:
> >
> > Select the cell with the "bad " formula, then:
> > <Ctrl> <Shift> <~>
> > Then,
> > <F2>
> > Then
> > <Enter>
> >
> > What you did here was format the cell to "General", then re-entered it.
> > --
> >
> > HTH,
> >
> > RD
> > ==============================================
> > Please keep all correspondence within the Group, so all may benefit!
> > ==============================================
> >
> >
> > "Mindie" <Mindie@discussions.microsoft.com> wrote in message
> > news:AB6A5082-8617-421F-8AE5-13AB58B3A006@microsoft.com...
> > The formula result does not display in the cell, instead the formula
itself
> > displays in the cell. I have tried different formats but continue to
have
> > the same problems.
> >
> >
> >

I was having the same problem, and your tip (format to general and edit)
solved it. Why would Excel work that way? Seems like a bug.

"Ragdyer" wrote:

> Thanks for the feed-back ... BUT ... out of curiosity,
> Which one "did the trick" ?
> --
> Regards,
>
> RD
>
> ---------------------------------------------------------------------------
> Please keep all correspondence within the NewsGroup, so all may benefit !
> ---------------------------------------------------------------------------
> "Mindie" <Mindie@discussions.microsoft.com> wrote in message
> news:FF306B23-DB23-4E78-A8F5-BA7DA23D1E54@microsoft.com...
> > Thanks, that did the trick!
> >
> > "RagDyeR" wrote:
> >
> > > Look at:
> > > <Tools> <Options> <View> tab,
> > > And make sure that "Formulas" is *UNchecked*.
> > >
> > > If it already is unchecked, try this:
> > >
> > > Select the cell with the "bad " formula, then:
> > > <Ctrl> <Shift> <~>
> > > Then,
> > > <F2>
> > > Then
> > > <Enter>
> > >
> > > What you did here was format the cell to "General", then re-entered it.
> > > --
> > >
> > > HTH,
> > >
> > > RD
> > > ==============================================
> > > Please keep all correspondence within the Group, so all may benefit!
> > > ==============================================
> > >
> > >
> > > "Mindie" <Mindie@discussions.microsoft.com> wrote in message
> > > news:AB6A5082-8617-421F-8AE5-13AB58B3A006@microsoft.com...
> > > The formula result does not display in the cell, instead the formula
> itself
> > > displays in the cell. I have tried different formats but continue to
> have
> > > the same problems.
> > >
> > >
> > >
>
>

Why would XL work which way?
Change format to Text ... Or ... Have text that *looks* like formulas, not
be allowed to work as formulas?

All default formatting on new WSs is "General".
SO ... how did the formatting change to Text?

That can only be answered by you, the user!
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

keigwin" <keigwin@discussions.microsoft.com> wrote in message
news:4B3631B1-8948-433D-A1B6-D4504C17BD09@microsoft.com...
> I was having the same problem, and your tip (format to general and edit)
> solved it. Why would Excel work that way? Seems like a bug.
>
> "Ragdyer" wrote:
>
> > Thanks for the feed-back ... BUT ... out of curiosity,
> > Which one "did the trick" ?
> > --
> > Regards,
> >
> > RD
> >
>
> --------------------------------------------------------------------------
-
> > Please keep all correspondence within the NewsGroup, so all may benefit
!
>
> --------------------------------------------------------------------------
-
> > "Mindie" <Mindie@discussions.microsoft.com> wrote in message
> > news:FF306B23-DB23-4E78-A8F5-BA7DA23D1E54@microsoft.com...
> > > Thanks, that did the trick!
> > >
> > > "RagDyeR" wrote:
> > >
> > > > Look at:
> > > > <Tools> <Options> <View> tab,
> > > > And make sure that "Formulas" is *UNchecked*.
> > > >
> > > > If it already is unchecked, try this:
> > > >
> > > > Select the cell with the "bad " formula, then:
> > > > <Ctrl> <Shift> <~>
> > > > Then,
> > > > <F2>
> > > > Then
> > > > <Enter>
> > > >
> > > > What you did here was format the cell to "General", then re-entered
it.
> > > > --
> > > >
> > > > HTH,
> > > >
> > > > RD
> > > > ==============================================
> > > > Please keep all correspondence within the Group, so all may benefit!
> > > > ==============================================
> > > >
> > > >
> > > > "Mindie" <Mindie@discussions.microsoft.com> wrote in message
> > > > news:AB6A5082-8617-421F-8AE5-13AB58B3A006@microsoft.com...
> > > > The formula result does not display in the cell, instead the formula
> > itself
> > > > displays in the cell. I have tried different formats but continue
to
> > have
> > > > the same problems.
> > > >
> > > >
> > > >
> >
> >