I need to custom format a percentage number so that it appears formatted as: > -5%
When I go to format cells, custom category, I input: “> “0%
This works well for positive numbers, but for negative numbers it ends up showing as: -> 5%
So the negative sign ends up showing to the left of the “>” symbol.
Any ideas on how to fix this?
Thank you for any help.
When I go to format cells, custom category, I input: “> “0%
This works well for positive numbers, but for negative numbers it ends up showing as: -> 5%
So the negative sign ends up showing to the left of the “>” symbol.
Any ideas on how to fix this?
Thank you for any help.