negative number formats

  1. G

    Sort Pivot Table by Negative Percent Values

    Hello, I have a Pivot Table that I created showing Year over Year (YOY) changes and I would like to sort this Pivot table to show Negative Values on top. I am showing years 2019,2020,2021, and 2022 and I would like to show the negative(YOY) for each year on top of the table. Is there a way to...
  2. M

    How to correct negative number format

    Many times our system gives us #’s like the first column but it can’t be changed to currency because of the negative sign being after the #. How can I change the first column to look and function like the second? <tbody> 25- $ (25.00) 45- $ (45.00) 81- $ (81.00) </tbody>
  3. J

    Negative number formats change when multiple users share a spreadsheet, causing frustration

    My entire Finance Department wants to show negative numbers with parentheses -- as (1), not as -1. I created a custom format that does this for me, and which aligns the decimal points. When other people in my department open a file that I created, they see the negative number as I want them to...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top