Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula Displays in One Cell
The errant cells are apparently formatted to TEXT............tyy deleting
just the equal sign, and then reinstating it....... Vaya con Dios, Chuck, CABGx3 "BCBC" wrote: I am creating a multi-page workbook. On Sheet 1, there is a cell where users can type in their name. On the Sheet 2, I want the name to automatically appear based on what is typed in Sheet 1. In the cell where I want the name to automatically appear, I type "=", and then I go back to Sheet 1 and click the cell where users type their name. After I click Enter, the formula appears in the cell, rather than the result. I have several other similar setups on the same page and this does not happen to them. How do I make the result show in this cell rather than the formula? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula Displays in One Cell
Happy to help..........thanks for the feedback.
Vaya con Dios, Chuck, CABGx3 "BCBC" wrote: Thanks Chuck - that did it! "CLR" wrote: The errant cells are apparently formatted to TEXT............tyy deleting just the equal sign, and then reinstating it....... Vaya con Dios, Chuck, CABGx3 "BCBC" wrote: I am creating a multi-page workbook. On Sheet 1, there is a cell where users can type in their name. On the Sheet 2, I want the name to automatically appear based on what is typed in Sheet 1. In the cell where I want the name to automatically appear, I type "=", and then I go back to Sheet 1 and click the cell where users type their name. After I click Enter, the formula appears in the cell, rather than the result. I have several other similar setups on the same page and this does not happen to them. How do I make the result show in this cell rather than the formula? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula Displays in One Cell
Thanks Chuck - that did it!
"CLR" wrote: The errant cells are apparently formatted to TEXT............tyy deleting just the equal sign, and then reinstating it....... Vaya con Dios, Chuck, CABGx3 "BCBC" wrote: I am creating a multi-page workbook. On Sheet 1, there is a cell where users can type in their name. On the Sheet 2, I want the name to automatically appear based on what is typed in Sheet 1. In the cell where I want the name to automatically appear, I type "=", and then I go back to Sheet 1 and click the cell where users type their name. After I click Enter, the formula appears in the cell, rather than the result. I have several other similar setups on the same page and this does not happen to them. How do I make the result show in this cell rather than the formula? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
My formula returns a result but the cell displays a zero? | Excel Worksheet Functions | |||
Valid formula result in Function Box but Cell displays #VALUE | Excel Discussion (Misc queries) | |||
Cell displays formula and not result | Excel Discussion (Misc queries) | |||
GET.CELL | Excel Worksheet Functions | |||
Formula window displays correct answer while cell displays incorre | Excel Worksheet Functions |