If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
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? |
#3
|
|||
|
|||
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? |
Thread Tools | |
Display Modes | |
|
|