Show Formula / Hide Formula

D

DejaVu

I have some data in (for example) column A:
5
49
4

I don't want to see the formula when I enter this formula into A4:
=SUM(A1:A3)

I want it to show me: 58
And NOT =SUM(A1:A3)

I went to Format | Cells | Protection Tab and "Locked" is not checked.

I'm at a loss and I cannot get it to show anything but the formula.


TIA for any help!

DejaVu
 
P

Paul Sheppard

DejaVu said:
I have some data in (for example) column A:
5
49
4

I don't want to see the formula when I enter this formula into A4:
=SUM(A1:A3)

I want it to show me: 58
And NOT =SUM(A1:A3)

I went to Format | Cells | Protection Tab and "Locked" is not checked.

I'm at a loss and I cannot get it to show anything but the formula.


TIA for any help!

DejaVu
Click to expand...

Hi DejaVu

Try Tools > Options > View Tab, under Window Options at the bottom,
uncheck the formula box
 
F

FSt1

hi,
check the cell with the formula to see if there is an apostrophe ' in front
of the equal sign. if so remove it. and apostrophe in front of a formula
makes the formula show up a text and not a formula. Post back if that is not
it.

Regards
FSt1
 
D

Dave Peterson

Make sure the cell is formatted to General (or Number)--anything but Text.
(Format|Cells|number tab)

Then select that cell, hit F2 followed by enter.

If you still see the formula, make sure you're not viewing formulas:

tools|options|view tab|make sure Formulas is not checked.
 
D

DejaVu

Thanks to all who provided responses. I should have been more specific
on what all I had tried. I had already tried to go to Tools > Options
and Formulas was not checked.
Click to expand...

I am 100% sure that there is not an apostrophe in front of my formula.

Finally - Thanks Dave! The cell was formatted as text. I tried that
once before, but I never re-entered the formula. I just assumed it
would update automatically.

Problem Solved!!

Thanks All!

DejaVu
 
Top