#1
|
|||
|
|||
Negative Percentage
What formatting do I use in order to enter (6.5%) into a cell? I tried number and percentage formatting and it doesn't work. HELP!
Thank you in advance |
#2
|
|||
|
|||
Percentage with one decimal place means if you enter 6.5, 6.5% is shown. The actual value is 0.065.
|
#3
|
|||
|
|||
Thank you Kenneth, but I need it to be a negative number within parenthesis.
|
#4
|
|||
|
|||
I was wondering what you meant by negative.
You will have to add a custom format. If you want red font if negative and ()'s, and one decimal place. #,##0.0%;[Red](#,##0.0%) |
#5
|
|||
|
|||
Thank you so much for all of your help.
|
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How does Excel put values on negative degree(s)? | JUSTIN CMM | Excel | 1 | 01-14-2016 12:41 AM |
Negative total float | loukas | Project | 2 | 11-29-2015 10:38 AM |
Excel VBA to convert number to negative | dakm63 | Excel Programming | 1 | 05-26-2015 10:49 AM |
Custom formatting to make negative numbers show w/o negative sign on charts | todor | PowerPoint | 3 | 01-16-2013 03:45 AM |
Sum required without consider the negative amount | PRADEEPB270 | Excel | 2 | 08-22-2011 04:23 AM |