| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
When I enter a formula it shows the formula not the result
|
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
When I enter a formula it shows the formula not the result
Sounds like the cell is formatted as TEXT.
Format the cell as General. Then, with the cell still selected hit function key F2 then hit ENTER -- Biff Microsoft Excel MVP "Dominic" wrote in message ... |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
When I enter a formula it shows the formula not the result
And if you see the formula in each cell, maybe you're looking at formulas:
Tools|Options|view tab|Uncheck formulas ctrl-` control-backquote (near the 1/! on my USA keyboard) is the shortcut key Dominic wrote: -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| When I enter a formula, Excel shows the formula not the results | Excel Worksheet Functions | |||
| Formula shows as the result? | Excel Discussion (Misc queries) | |||
| Cell shows formula and not the result of the formula. | Excel Worksheet Functions | |||
| Cell shows formula and not the result of the formula. | Excel Worksheet Functions | |||
| Cell doesn't show formula result - it shows formula (CTRL + ' doe. | Excel Worksheet Functions | |||
Linear Mode
