Need to combine 2 columns & have the #s formatted to $#,###,### and $##,###.

Copper Contributor

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 #, 

1 Reply

@PamJ_6476 

You may use

=TEXT(<number1>,"$#,###,###") & CHAR(10) & TEXT(<number2>,"$#,###,###")

or like