Hi,
I have an Excel formatting question that I thought was pretty straightforward, but nothing seems to be giving me the desired result.
Basically, I want to combine a number (in one cell) with text in another cell, while retaining the correct formatting of the number. It is all working EXCEPT that my negative values are no longer appearing in red (as is typical with the Currency formatting and other finance formats).
My number is in A1 [let's say it's negative 10 dollars, appearing as ($10)]; my text is in B1 [let's say it's HELLO].
The basic formula would be =A1&" "&B1.
To retain the currency formatting I tried =DOLLAR(A1,0)&" "&B1
This works fine [resulting in ($10) HELLO] with the exception of the negative numbers. They appear in the correct format [i.e., ($10)]. But, the negatives (like the positives) are in black instead of red.
So I tried =TEXT(A1,"$#,##0_);[Red]($#,##0)")&" "&B1
Even with this explicit number format, the Red designation is ignored.
Can anyone think of a trick to get this to work?
Thanks!
I have an Excel formatting question that I thought was pretty straightforward, but nothing seems to be giving me the desired result.
Basically, I want to combine a number (in one cell) with text in another cell, while retaining the correct formatting of the number. It is all working EXCEPT that my negative values are no longer appearing in red (as is typical with the Currency formatting and other finance formats).
My number is in A1 [let's say it's negative 10 dollars, appearing as ($10)]; my text is in B1 [let's say it's HELLO].
The basic formula would be =A1&" "&B1.
To retain the currency formatting I tried =DOLLAR(A1,0)&" "&B1
This works fine [resulting in ($10) HELLO] with the exception of the negative numbers. They appear in the correct format [i.e., ($10)]. But, the negatives (like the positives) are in black instead of red.
So I tried =TEXT(A1,"$#,##0_);[Red]($#,##0)")&" "&B1
Even with this explicit number format, the Red designation is ignored.
Can anyone think of a trick to get this to work?
Thanks!