Dec 05 2019 10:38 AM
I need to combine 2 columns, and have the top #s formatted to $#,###,### and add a return and also the bottom number to show $#,###,###. For Example
$1,000,000 char(10)
$10.00
I used index match formula to get the top number but my number would come up like below:
1000000
$10.00 (i was able to use the &"$" and round formula to fix the bottom value, but I can't see to fix the top value.
Pls. help
I was able to add $ to the bottom #,
Dec 05 2019 12:34 PM
You may use
=TEXT(<number1>,"$#,###,###") & CHAR(10) & TEXT(<number2>,"$#,###,###")
or like