I want to reference another cell, and display not only the value of the referenced cell, but also it's format. For example:
If cell A8 contains `=B8`
and B8 displays as `$1,234.56`
I want cell A8 to display $1,234.56
and not just 1234.56
.