# Change a negative sign to positive

#### Mjkqb

##### New Member
What is the best way to change a negative number with a minus sign to display with a plus sign.
I don't want to affect any positive numbers, only negative.
-1 should display as +1.
1 should display as 1.

Below is the formula I'm using.
=MIN(ROUND(MIN(B10,18)*112/113+63.3-70,0),18)

Can this formula be modified to include the minus/plus change?

Thanks

### Excel Facts

Quick Sum
Select a range of cells. The total appears in bottom right of Excel screen. Right-click total to add Max, Min, Count, Average.

#### steve the fish

##### Well-known Member
If i understand you can use:

=A1*SIGN(A1)

This will produce positives as they were and negatives will become positive. That what you meant?

#### etaf

##### Well-known Member
ABS(A1)
Returns the absolute value of a number. The absolute value of a number is the number without its sign.

so +ve numbers stay positive and -ve numbers become positive

#### RoryA

##### MrExcel MVP, Moderator
What is the best way to change a negative number with a minus sign to display with a plus sign.
Do you only want to change the displayed value, or alter the actual value?

#### Mjkqb

##### New Member
Do you only want to change the displayed value, or alter the actual value?
Only the displayed value.
If it is a negative number it needs to be displayed as a positive number with a plus sign.
The other positive numbers should be absolute with no sign.
Including a screen shot.
You can see there are only a couple of cells with a -1 value, but they must be displayed as +1

#### Attachments

• Help_minus_positivePNG.PNG
99.1 KB · Views: 8

#### RoryA

##### MrExcel MVP, Moderator
All you should need is a custom number format like:
0;”+”0

#### Mjkqb

##### New Member
All you should need is a custom number format like:
0;”+”0
Thanks so much. That worked perfectly. Pretty new at this, just curious about the quotation marks. I had to remove them as they were being displayed.

Replies
8
Views
66
Replies
2
Views
225
Replies
3
Views
400
Replies
2
Views
365
Replies
3
Views
1K

1,195,581
Messages
6,010,574
Members
441,557
Latest member
Jbest23

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