I have a variable, CostChange, that is equal to the value of a given cell formatted as $#,##0.00. However, when I use CostChange in a message variable, such as:

Msg = "Unit cost increased by " & CostChange

CostChange loses all its formatting. How do I find a way to fix this?