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?
Bookmarks