Excel Number Formatting

[liampog]

Hi there

I currently use the custom number format:

+0  ;[Red](0)

This allows me to display positive numbers as +1, +5, etc and negative numbers in RED and in brackets.

However, when the value is 0 it shows as +0.

Is there any way to define a format for when the value is 0?

 

[Vidar]

Try this:
+0;[Red](-0);0

 

[Momentman]

Like this maybe
+0;[Red](0);0

 

[liampog]

Like this maybe
+0;[Red](0);0

Perfect thanks! Knew it would be easy!