Custom Formatting for percent

[tljans]

We always show negative %'s with () instead of the - sign. However, when it's a rounded 0, but still negative, instead of (0%), we want to show 0%. We have various work arounds but none are great. I would like to use a custom number format over conditional formatting. I've gotten this far... [>-0.0499]0%;(0%) but this removes the () from EVERYTHING > -0.0499 for example, I want -0.005 to show as (1%), but -0.0499 to show as 0% Any ideas? Thanks in advance!

 

[mole999]

how about > 0.#%;(0.#)% custom format

 

[tljans]

how about > 0.#%;(0.#)% custom format

Thank you! We ended up going with: [>-0.005]0%;(0%) and it works perfectly. It seems so obvious once you get it figured out!