I am trying to get D5 and D6 into cell C6 so that I looks like this ($15,000.00 - $25,000.00) The formula I used to do this is :
=DOLLAR(D5)&" - "&DOLLAR(D6)
My first question is, is there an easier/better way to accomplish this?
My second question, how will I remove the decimal places in C6, as the number formatting decimal spacer doesn't work for this situation?
Please see screen shot below.