troubleshooting Question

Custom number format for percentage values between -0.99% and 0.99% (two digits), other percentage numbers no digits

Avatar of Andreas Hermle
Andreas HermleFlag for Germany asked on
Microsoft ExcelMicrosoft Office
2 Comments1 Solution11 ViewsLast Modified:
Dear Experts:

I have seen it somewhere but cannot recreate it:

I would like to custom format percentage figures between -0.99% and 0.99% with two decimal places, other figures such as 5,83% or 4,2% should be formatted as 6% or 4%.

The custom number format I think is something like ...

[<0,01],0%,...

I just cannot remember. Help is very much appreciated. Thank you very much in advance.

Regards, Andreas.

I have attached a sample file for your convenience.
custom-format-percentages.xlsx 

ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 1 Answer and 2 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 2 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros