Hello. How can I get a + and - in front of % numbers? Thanks!!
Hello. How can I get a + and - in front of % numbers? Thanks!!
Did you check the 'Number' Format options?
Maybe
Custom Format
- Right click cell (or Ctrl + 1)
- Format Cells
- Number
- Custom
- Type: +0%;-0%;;
Number Formats
Last edited by jeffreybrown; 11-10-2015 at 08:19 PM.
HTH
Regards, Jeff
Available number format codes and instructions for building custom number formats (I found this one of my most referred to help files while learning Excel):
https://support.office.com/en-us/art...3-80F18B4EAE68
It's not clear to me exactly what you are trying to do. To get the text string "+ and -" in front of numbers formatted as per cent, enclose the text in quotation marks along with the usual per cent number format. Something like "+ and -"0.00%.
Originally Posted by shg
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks