Excell will not solve for a formula entered into a cell

Question

When a formula is entered into a cell and hit enter the formula is shown and not the answer.

jkpieterse · Answer

Press and hold the control-key on your keyboard and hit the ` key (the one directly above your Tab key). Let go of all keys. This control ` combination toggles between formula view and "normal" view.

paul_brown_141 · Answer

Ok but what does that give me? I see the formulas but I still can't see the formula resolved

detlef_lewin · Answer

The cell is formatted as "Text". Format as "General" or "Number". Then press F2 and ENTER.

jkpieterse · Answer

As I said, the short-cut key should toggle between displaying formulas and displaying results. Perhaps it doesn't work for you. Alternatively, go to File, Options, Advanced tab, scroll down to "Display options for this worksheet" and uncheck the box stating "Show formulas instead of their calculated results".

paul_brown_141 · Answer

When I do what you asked the cells with formulas had the formula shown will change back when toggled again. What is happening is some cells will not give the results of the formula but the formula itself. To Lewin's comment I did that. All other formulas in the worksheet work fine and all work ok on another computer

Forum Discussion

Excell will not solve for a formula entered into a cell

8 Replies

Resources