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? |
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? |
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? |
All times are GMT +1. The time now is 09:28 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com