ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Percentage formatting (https://www.excelbanter.com/excel-discussion-misc-queries/77995-percentage-formatting.html)

HJ
Percentage formatting
 
Is there a way to format a cell that has a negative % to be (100%) vs. -100%?

HJ
Percentage formatting
 
Never mind. I figured it out. I used the custom format of 0% and added the
following to the format: 0%;(0%)

"HJ" wrote:

Is there a way to format a cell that has a negative % to be (100%) vs. -100%?


All times are GMT +1. The time now is 03:58 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com