| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula showing in cell
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula showing in cell -- Never mind
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 "Carolyn" wrote: 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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula showing in cell
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 On Thu, 1 Apr 2010 11:53:06 -0700, Carolyn wrote: 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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula showing in cell -- Never mind
Too late.
Always best to keep in the same thread rather than posting a new one. Gord Dibben MS Excel MVP On Thu, 1 Apr 2010 11:59:01 -0700, Carolyn wrote: 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 "Carolyn" wrote: 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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula showing in cell
Format the cell to something other than text, re-enter the formula.
-- Best Regards, Luke M "Carolyn" wrote in message ... 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cell showing formula instead of date | Excel Discussion (Misc queries) | |||
| Problem with formula showing in cell | Excel Worksheet Functions | |||
| showing and copying a formula in a cell | Excel Worksheet Functions | |||
| formula in cell not showing result | Excel Worksheet Functions | |||
| Formula result not showing in cell | Excel Worksheet Functions | |||
Linear Mode
