It does sound like the cell where you input the formula was earlier
pre-formatted as TEXT (unknown to you of course), that's why. Re-format that
cell as general/number (via FormatCells), then re-confirm the formula by
clicking inside the formula bar and pressing ENTER. You need to re-confirm
the formula to wake Excel up. Just re-formatting the cell alone will NOT
trigger it. Success? hit the YES below
--
Max
Singapore
---
"sarah - northampton" wrote:
I am trying to concatenate cells and have the result execute within a
formula. I am ending up with: =sheet4!A2 instead of the value that is
contained in that location.