Formula stays in the cell

M

Mindie

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

JulieD

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
 
T

tjtjjtjt

Sounds like Excel is set to display formulas.

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

tj
 
R

RagDyeR

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


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

keigwin

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

Ragdyer

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

Mr. H

I am also having the same issue with the formulas. The two processes of
changing the format to general-->F2-->Enter and the find/replace "=" works
well to fix the problem. However, once I try and edit the formula, it
reverts back to displaying the formula itself rather than the result. Any
suggestions on how to prevent this from happening?
 
D

Dave Peterson

Saved from a previous post.

Excel likes to help.

Try this on a test worksheet.
Select A1 and hit ctrl-; (to put the date in the cell)
now select B1 and type: =a1

Notice that excel changed the format of B1 to match the format in A1.

Now format D1 as Text.
put ASDF in D1
put =D1 in E1
You see ASDF.

With E1 selected, hit the F2 key and then enter (to pretend that you're changing
the formula).

Excel has "helped" you by changing that cell's format to text.

I don't know of any way of changing this behavior.

I just select the cell, and reformat it to General (or whatever I wanted). I
hit F2 and then enter (to reenter that formula).

Sometimes this feature is nice, sometimes it ain't.
 
Top