Show Plus Sign for positive numbers

Desu Nota from Columbus

Well-known Member
Joined
Mar 17, 2011
Messages
556
I currently have percentages that I am interested in showing a + sign in front of the positive numbers.

How do you do this? I tried a quick search and couldn't get anything to work.

The numbers are currently formatted as Percentage (1 decimal place).
 
Thank you! I am using, the last one for true zero value without a +/-, adding 2 spaces to 0 value to have those line up better with +/- value, since the numbers are formatted as Centered. If they were

+0.00;-0.00; 0.00

to properly code Eyeglass prescriptions over time for myself and my family. This helps keep the data exactly as entered on the original prescription.
 
Upvote 0

Excel Facts

Select all contiguous cells
Pressing Ctrl+* (asterisk) will select the "current region" - all contiguous cells in all directions.

Forum statistics

Threads
1,224,617
Messages
6,179,914
Members
452,949
Latest member
beartooth91

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Back
Top