Here is a UDF solution that will work:
Function GetFormula(Cell)
GetFormula = Cell.Formula
End Function
Then in B1 enter =GetFormula(C123)
--
Regards,
Dave
"Omunene" wrote:
Cell C123 contains the value 99.
I want cell A1 to display that value (99) and cell B1 to display the formula
(=C123).
I put =C123 in cell A1. What do I put in cell B1?
I know I can toggle between value and formula but how do I get them to both
display side-by-side at once?
THANK YOU!
|