Formula showing in cell

C

Carolyn

When I type a formula in a cell after hitting enter, the forumla not the
value appears in the cell. It is not toggled to show the formula nor are the
existing formulas in other cells showing.

Any ideas?

Carolyn
 
C

Carolyn

I had copied cells from another workbook. When I inserted a column it must
have brought in something that made the formula text. When I copied and did
an paste special into the column, the formulas started entering correctly.

Carolyn
 
G

Gord Dibben

Cell format is most likely Text.

Re-format the cell to General then F2 and ENTER to re-enter the formula.


Gord Dibben MS Excel MVP
 
G

Gord Dibben

Too late.

Always best to keep in the same thread rather than posting a new one.


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dragging a formula across the row in 2007 2
Cell formulas 2
Automatically Enter Formula in a Cell After Entering Data in Another Cell 0
Complicated Formula 1
Excel VBA 1
Value won't show correctly in cell unless I double click formula, 1
Sum not showing up 2
Formula Bar - display of content 4

Top