Problem with formula showing in cell

  • Thread starter Thread starter andyK
  • Start date Start date
A

andyK

I am having a problem with a excel document that I exported from a pdf file.
When I enter a formula in a cell the cell shows the formula continously. I
know that something happened like this a few years ago and there was an
adjustment that could be made in calculation and it would be fixed but that
doesn't seem to be working in this instance. Any suggestions?
 
The cells are formatted as Text.

Format all cells to General then re-enter the formula by F2 + ENTER.


Gord Dibben MS Excel MVP
 
Thanks so much. Big help.

Andy

Gord Dibben said:
The cells are formatted as Text.

Format all cells to General then re-enter the formula by F2 + ENTER.


Gord Dibben MS Excel MVP
Click to expand...
 

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

using the =page! feature to transpose a row to column 0
Why does forumula show in cell instead of formula result? 2
Counting # of Formulas in a column with formulas and entered data 1
CountIf previous cell formula 0
Use & with two formulas 2
Formulas displayed in cell rather than calculated values? 4
Why won't target cell data changes trigger formula evaluation? 3
how do I get a function formula cell to format as a number? 5

Back
Top