Unless I'm missing something, in cell b2

=b1

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"ccgsuper" wrote in message
...
Is there a way to see the "value" of a formula in cell B1 in cell B2
without
copying and using paste special, "Value"? I would like it to be automatic
if
the value in B1 changes.