Sign Flip Any Number Format in Pivot Table

[kyleswanson]

Hello,

I am wondering if there is any easy way to take any number format in an Excel Pivot Table and essentially flip the sign. Preferably, any positive numbers would show up in parentheses (accounting format) and any negative numbers would appear to be positive without parentheses. In the case of percentages, would prefer the sign flip with a "-" sign instead of the parentheses.

Example:
Old Number: 30
New Number after applying sign flip edit: (30)

Another Example:
Old Number: 2.7%
New Number: -2.7%

As you can see, there are quite a few custom formats that I would like to apply this sign flip too, so wondering if these is a simple edit that can be made to any given format to sign flip it.

If there is no easy all inclusive solution, here are a few formats that would be awesome to know how to sign flip:

_($* #,##0,_);_($* (#,##0,);_($* "-"_);_(@_) – accounting thousands $
_(* #,##0,_);_(* (#,##0,);_(* "-"_);_(@_) - accounting thousands
_(* #,##0_);_(* (#,##0);_(* "-"_);_(@_) - accounting
0.0% - percentage with 1 decimal point

Thanks and really appreciate any insight on this!!

Kyle

 

[Alex Blakenburg]

The way the custom number formats work is that they have 4 positions separated by semi-colons which represent the following:-
Positive ; Negative ; Zero ; Text
The default for percent is effectively
0%;-0%
All you need to do is switch the sign around
-0%;0%

20210507 Custom Number Format percent.xlsx
	A	B	C	D
5	Setting	Format	Postive	Negative
6	Default Format		10%	-10%
7	Custom Format	-0%;0%	-10%	10%
Sheet1

 

[Alex Blakenburg]

For the 30 and negative 30, I am pretty sure brackets is already a custom format, so use that custom format and create an new one swapping what is in position 1 (positive) with position 2 (negative)