| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Why is my cell displaying the formula ?
I tried formatting the cells as general before and after I entered the
formula but I kept seeing the formula in the cell not the result. I eventually added a new sheet and it worked ok.But I still wanted to know what happened |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Why is my cell displaying the formula ?
Hi,
Try this. Hold down the Ctrl key and tap ` which is to the left of the 1 key and you should see your formulas. Do it again and you'll get your formula results back. The other way is Tools|Options|View tab and check/un-check formulas. Is that what you saw? Mike "STARR" wrote: I tried formatting the cells as general before and after I entered the formula but I kept seeing the formula in the cell not the result. I eventually added a new sheet and it worked ok.But I still wanted to know what happened |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula result not displaying in cell | Excel Worksheet Functions | |||
| Displaying Formula Results in Cell | Excel Discussion (Misc queries) | |||
| A formula for displaying the cell reference of the selected cell | Excel Discussion (Misc queries) | |||
| Text in formula bar is not displaying in cell | Excel Discussion (Misc queries) | |||
| Text in formula bar is not displaying in cell | Excel Discussion (Misc queries) | |||
Linear Mode
