Windows Forum

Ask something
Discussion Locked

Excel formulas showing in cell, not form

0 helpful
10 replies

by nsohenick 1 view

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

How come when I use formulas in excel sometimes it shows me just the formula and not the answer. I hit CRTL tilda and it still doesnt show me the value. Sometimes when I created a new document and paste the values into and then perform my calc it works. Then I have to paste it back into the original worksheet. Can someone tell me what I'm doing wrong??!!

Thanks

Nicole S

10 replies

by rawright

My boss has this trouble, and invariably it's caused by "something" removing the = symbol that must precede the formula. Whether the program is deleting it, or he's being a bit careless in typing, we can't determine. But without that = sign, the cell treats the formula as a text value.

by nsohenick

The equal signs are definitely there. I use the formula wizard to create them. It still doesn't recognize the formula....

by jpomposelli

You said you pressed Ctrl + ~ . You have to press Ctrl + ` . Do not press the shift key to get the tilde. This might be your problem. Or just go to:
Tools
Options
View Tab
And Make sure the Formulas check box is unchecked.

Hope this helps,
Jason

by igorsky

Excel will display exactly what you type if the cell has been formatted as text. If you want the result of your formula to be displayed or used as text, you can format the cell - after you have entered the formula.

This discussion is closed to new replies.