# Formatting negative value when using Concatenate function

#### excelq

##### New Member
Say I have two values in two different cells: A1) -2.568 and B1) 7.134
in another cell, I want to combine the two but have it look this way:
-\$2.6 / \$7.1
I got close using the concantenate formula but it on the negative values, it returns the '-' sign before the '\$' sign (\$-2.6, rather than -\$2.6)

Here's the formula I used:
="\$"&(ROUND(A1,1))&" / \$"&(ROUND(B2,1))

which returns: \$-2.6 / \$7.1

Is there a way to have the '-' sign come BEFORE the '\$' sign?

any help would be appreciated!

### Excel Facts

What is the fastest way to copy a formula?
If A2:A50000 contain data. Enter a formula in B2. Select B2. Double-click the Fill Handle and Excel will shoot the formula down to B50000.

#### Artemus

##### Board Regular
Try this:
=IF(A1<0,"-","")&"\$"&(ROUND(ABS(A1),1))&" / "&IF(B2<0,"-","")&"\$"&(ROUND(ABS(B2),1))

#### Norie

##### Well-known Member

=TEXT(ROUND(A1,1), "\$#.##")&"/"&TEXT(ROUND(B1,1), "\$#.##")

#### Chas17

##### Well-known Member
..

=IF(A1<0,"- \$"&(ROUND(ABS(A1),1)),"\$"&(ROUND(A1,1)))&" / " &IF(B1<0,"- \$"&(ROUND(ABS(B1),1)),"\$"&(ROUND(B1,1)))

#### excelq

##### New Member
thank you all!!!!!

Replies
3
Views
238
Replies
0
Views
60
Replies
2
Views
101
Replies
2
Views
51
Replies
3
Views
657

1,127,387
Messages
5,624,402
Members
416,026
Latest member
melvic69

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back