Cell displays formula, not result?

[ctc]

How do i configure excel to display the results of the sum of a set of
numbers instead of displaying the formula?

Ex. I want to add the numbers of several different cells so I compose the
equation "=R22+R34+R35+R37" in a results cell. However the results cell
doesn't display the sum of these fields. instead it displays
"=R22+R34+R35+R37".

[Marcelo]

try to use
=R22+r34+r35+r37,

if you put " on the formulas excel will see it as a text

hope this helps
regards from Brazil going to the 6th
Marcelo

"ctc" escreveu:

> How do i configure excel to display the results of the sum of a set of
> numbers instead of displaying the formula?
>
> Ex. I want to add the numbers of several different cells so I compose the
> equation "=R22+R34+R35+R37" in a results cell. However the results cell
> doesn't display the sum of these fields. instead it displays
> "=R22+R34+R35+R37".

[Kevin B]

Click TOOLS on the menu and select OPTIONS. If necessary, click the VIEW
tab. In the panel named WINDOW OPTIONS verify that there isn't a check in
the FORMULAS check box. If there is, turn it off.
--
Kevin Backmann


"ctc" wrote:

> How do i configure excel to display the results of the sum of a set of
> numbers instead of displaying the formula?
>
> Ex. I want to add the numbers of several different cells so I compose the
> equation "=R22+R34+R35+R37" in a results cell. However the results cell
> doesn't display the sum of these fields. instead it displays
> "=R22+R34+R35+R37".

[Mark Lincoln]

Also check Tools|Options; under Windows Options on the View tab, make
sure that Formulas is unchecked.

ctc wrote:
> How do i configure excel to display the results of the sum of a set of
> numbers instead of displaying the formula?
>
> Ex. I want to add the numbers of several different cells so I compose the
> equation "=R22+R34+R35+R37" in a results cell. However the results cell
> doesn't display the sum of these fields. instead it displays
> "=R22+R34+R35+R37".

[T Kirtley]

It is most likely that the cell with the formula in it is formatted as text.
If so, you should format the cell with something like 'Number' or 'General'
format and then re-edit the formula, (make sure it does not begin with quotes
as was the case in your post), and then the formula should work.

Otherwise, it is possible you have Excel in the 'Display Formulas' mode
which can be toggled on/off with the Ctrl^` key combination. (The ` key is
usually just beneath the Esc key, not to be confused with the single quote '
character)

HTH,

TK

"ctc" wrote:

> How do i configure excel to display the results of the sum of a set of
> numbers instead of displaying the formula?
>
> Ex. I want to add the numbers of several different cells so I compose the
> equation "=R22+R34+R35+R37" in a results cell. However the results cell
> doesn't display the sum of these fields. instead it displays
> "=R22+R34+R35+R37".

[angel simurina]

I have also been having this same problem lately too often. Before it would happen very rarely and was simple to fix. Now no matter how i format the cell, sheet or workbook it keeps happening and seems nearly impossible to fix!

[enoctis]

I have also been having this same problem lately too often. Before it would happen very rarely and was simple to fix. Now no matter how i format the cell, sheet or workbook it keeps happening and seems nearly impossible to fix!

The link below is to a thread that has a proposed fix. I haven't been able to test it out yet because the problem is at work, and I'm currently at home. The link will take you to the portion of the thread that you need, the previous replies to the topic were useless.

http://www.mrexcel.com/forum/excel-q...html#post89342

[Tank997]

One other thing I've seen that I didn't see mentioned here is a space in front of the = sign which can be fixed with the find and replace as pointed out on the MrExcel link above.

[enoctis]

The link below is to a thread that has a proposed fix. I haven't been able to test it out yet because the problem is at work, and I'm currently at home. The link will take you to the portion of the thread that you need, the previous replies to the topic were useless.

http://www.mrexcel.com/forum/excel-q...html#post89342

UPDATE: It worked. I simply selected the erroneous cells (one-by-one), pressed F2 and then hit ENTER without doing anything else.