Microsoft Office Forums Negative Percentage

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 08-27-2019, 08:00 PM
Karen615 Karen615 is offline Negative Percentage Windows 7 64bit Negative Percentage Office 2010 64bit
Advanced Beginner
Negative Percentage
 
Join Date: Jun 2011
Location: Chicago
Posts: 39
Karen615 is on a distinguished road
Default 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
Reply With Quote
  #2  
Old 08-27-2019, 08:26 PM
Kenneth Hobson Kenneth Hobson is offline Negative Percentage Windows 10 Negative Percentage Office 2016
Advanced Beginner
 
Join Date: Jun 2018
Posts: 37
Kenneth Hobson is on a distinguished road
Default

Percentage with one decimal place means if you enter 6.5, 6.5% is shown. The actual value is 0.065.
Reply With Quote
  #3  
Old 08-27-2019, 08:54 PM
Karen615 Karen615 is offline Negative Percentage Windows 7 64bit Negative Percentage Office 2010 64bit
Advanced Beginner
Negative Percentage
 
Join Date: Jun 2011
Location: Chicago
Posts: 39
Karen615 is on a distinguished road
Default

Thank you Kenneth, but I need it to be a negative number within parenthesis.
Reply With Quote
  #4  
Old 08-27-2019, 09:06 PM
Kenneth Hobson Kenneth Hobson is offline Negative Percentage Windows 10 Negative Percentage Office 2016
Advanced Beginner
 
Join Date: Jun 2018
Posts: 37
Kenneth Hobson is on a distinguished road
Default

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%)
Reply With Quote
  #5  
Old 08-28-2019, 08:47 PM
Karen615 Karen615 is offline Negative Percentage Windows 7 64bit Negative Percentage Office 2010 64bit
Advanced Beginner
Negative Percentage
 
Join Date: Jun 2011
Location: Chicago
Posts: 39
Karen615 is on a distinguished road
Default

Thank you so much for all of your help.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Negative Percentage How does Excel put values on negative degree(s)? JUSTIN CMM Excel 1 01-14-2016 12:41 AM
Negative Percentage Negative total float loukas Project 2 11-29-2015 10:38 AM
Negative Percentage 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


All times are GMT -7. The time now is 03:17 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2019, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2019 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft