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?