Probably Easy Answer!

[Guest]

When I write my formula in the cell then enter to move out, instead of the answer being displayed I see the formula on the sheet. What am I doing wrong. I've tried everything I can think of! Please help........

 

[Bob Phillips]

Try Ctrl-` (above the tab key) and see if that fixes it.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

When I write my formula in the cell then enter to move out, instead of the

answer being displayed I see the formula on the sheet. What am I doing
wrong. I've tried everything I can think of! Please help........

 

[Guest]

-----Original Message-----
When I write my formula in the cell then enter to move

out, instead of the answer being displayed I see the
formula on the sheet. What am I doing wrong. I've tried
everything I can think of! Please help........

.

Check that you haven't selected the option to have
formulas appear rather than formula results. Go to the
TOOLS drop-down menu, then to OPTIONS. Select the VIEW
table and make sure that there is NOT a check next to
FORMULAS in the Windows Options section.

Good luck!

 

[Gord Dibben]

Possibly the cells are pre-formatted as Text.

Select the cells and format to General.

F2 and Enter to change to valid formulas.

If you have many to change, select them and format as General then while still
selected, Edit>Replace

what: =
with: =

Replace all.

Gord Dibben Excel MVP

 

[Rojo Habe]

You are preceding the formula with an equals sign aren't you?

When I write my formula in the cell then enter to move out, instead of the

answer being displayed I see the formula on the sheet. What am I doing
wrong. I've tried everything I can think of! Please help........