| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula Showing In A Cell Instead of Proper Result | New Users to Excel | |||
| showing and copying a formula in a cell | Excel Worksheet Functions | |||
| create formula showing row height in a cell | Excel Discussion (Misc queries) | |||
| formula in cell not showing result | Excel Worksheet Functions | |||
| Formula result not showing in cell | Excel Worksheet Functions | |||
Linear Mode
