Number not retaining currency format

[Sum of all fears]

Hi all,

I'mhaving trouble using currency formatting in a cell with multiple values.

Column B shows one figure, Column C shows another, and I'd like column D to be "Column B - Column C," but I'm having trouble retaining the currency formatting (e.g. the comma separators). I created a formula that is able to show the $ signs and minus symbol, but the comma separators are stumping me.

Here is a sample worksheet with an example of the raw data and what I'd like it to look like. Would someone please assist me?
https://docs.google.com/spreadsheet...47gLfqBIj6Ex_2qr5XMzmYYBE/edit#gid=1064201644

Thank you!
-Andy

 

[Joe4]

Using this formula in cell D2 should do it:

=TEXT(B2,"$0,000.00") & " - " & TEXT(C2,"$0,000.00")

Then copy down for all rows.

 

[Rick Rothstein]

Give this formula a try...

=TEXT(B2,"$#,##0.00 - ")&TEXT(C2,"$#,##0.00")

 

[VoG]

Or

=DOLLAR(B2,2)&" - "&DOLLAR(C2,2)