| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula displays, not value
I am linking two files by having cells in one spreadsheet equal to
corresponding cells in another. However when I enter the equal sign in one sheet, then go to the other sheet and click on the corresponding cell then hit enter, the original cell displays the formula, not the value. I tried copying cells above which display correctly, but that does the same thing. Any ideas how to solve this problem? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula displays result in formula box but not in cell | Excel Discussion (Misc queries) | |||
| Formula displays result in formula box but not in cell | Excel Worksheet Functions | |||
| Copy formula so destination displays formula as text | Excel Discussion (Misc queries) | |||
| i edit a formula (excel) then it displays formula not answer | Excel Discussion (Misc queries) | |||
| Formula window displays correct answer while cell displays incorre | Excel Worksheet Functions | |||
Threaded Mode
