Problem with formula showing in cell
 

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?

Problem with formula showing in cell
 

The cells are formatted as Text.

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


Gord Dibben MS Excel MVP



On Wed, 6 Aug 2008 19:39:01 -0700, andyK
wrote:

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?

Problem with formula showing in cell
 

Thanks so much. Big help.

Andy

"Gord Dibben" wrote:

The cells are formatted as Text.

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


Gord Dibben MS Excel MVP



On Wed, 6 Aug 2008 19:39:01 -0700, andyK
wrote:

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?