Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell only shows formula entered
Excel 2003 - I am entering a formula into a cell. When I click the enter key
the cell only shows the formula, not the results. This has happened before and not sure what fixed it, but sometimes it does this and the next time the formula will work. I am trying to do a vlookup. But instead the cell just shows: =VLOOKUP(C:C,Sheet3!A:C,3,false). It won't display the result of the formula. I have shows formulas in the tools-option menu unchecked. Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell only shows formula entered
hit ctrl ` at the same time, this is the way to toggle between the result and
the actual formula "duketter" wrote: Excel 2003 - I am entering a formula into a cell. When I click the enter key the cell only shows the formula, not the results. This has happened before and not sure what fixed it, but sometimes it does this and the next time the formula will work. I am trying to do a vlookup. But instead the cell just shows: =VLOOKUP(C:C,Sheet3!A:C,3,false). It won't display the result of the formula. I have shows formulas in the tools-option menu unchecked. Thanks |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell only shows formula entered
Another thing to try:
Try formatting the cell as General (or anything but Text) then with that cell still selected F2 then enter duketter wrote: Excel 2003 - I am entering a formula into a cell. When I click the enter key the cell only shows the formula, not the results. This has happened before and not sure what fixed it, but sometimes it does this and the next time the formula will work. I am trying to do a vlookup. But instead the cell just shows: =VLOOKUP(C:C,Sheet3!A:C,3,false). It won't display the result of the formula. I have shows formulas in the tools-option menu unchecked. Thanks -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
The formula shows in cell but not the result | Excel Discussion (Misc queries) | |||
format a cell with a formula so an empty reference cell shows blan | Excel Discussion (Misc queries) | |||
cell shows 20. Formula shows 20. why not 540/27 | Excel Worksheet Functions | |||
Some text shows in the formula bar but not in the cell. | Excel Discussion (Misc queries) | |||
Cell doesn't show formula result - it shows formula (CTRL + ' doe. | Excel Worksheet Functions |