cpv
asked on
Reverse sign - condtionally - on numbers in Excel pivot table
How do you reverse the signage on a number in a pivot table - based upon some condition.
Crystal Reports has a simple reverse sign display, and you can create a condition for that formatting. I was hoping for something this simple.
Everything I have researched on the internet discusses multiplying by -1..... however that changes the integrity of the number - and would be overwritten if you were to paste the values.
In a pivot table, you need to add numbers based upon the actual signage..... however for financial statements, you would show expenses/COGS as positive numbers, even though they are subtracted in the calculation.
Crystal Reports has a simple reverse sign display, and you can create a condition for that formatting. I was hoping for something this simple.
Everything I have researched on the internet discusses multiplying by -1..... however that changes the integrity of the number - and would be overwritten if you were to paste the values.
In a pivot table, you need to add numbers based upon the actual signage..... however for financial statements, you would show expenses/COGS as positive numbers, even though they are subtracted in the calculation.
ASKER
What version of Excel are you referring to? This is 2007..... when I right click on the field in question, I can go to 'Value Field Settings', > Number Format > There is a Custom or Special, but not Customize.
sorry.. I thought the question was about crystal report. Anyways, evenin excel you can achieve this.
Right click on cells-> Format Cells->select Nuber tab->select Number category-> now on right handside you will see a box for "Negative Numbers:" -> select 2nd option in this. which is 1234 in red color.
This way it will no display the sign but negative numbers will be displayed in red color.
will this serve your purpose??!!!
Right click on cells-> Format Cells->select Nuber tab->select Number category-> now on right handside you will see a box for "Negative Numbers:" -> select 2nd option in this. which is 1234 in red color.
This way it will no display the sign but negative numbers will be displayed in red color.
will this serve your purpose??!!!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Drag your field on the report.
Right Click -> Click on "Format Field"
Go to "Number" Tab
Click on "Customize"
Go to "Number" tab
Go to the option "Negatives"
Select "None" from the dropdown