Custom Formats

[Paul W Smith]

I am trying to find a format that will give the following:

Positive numbers = + [number]
Negative numbers = - [number]
zero = 0 (neither sign)

I have ("+ 0; - 0") which achieves the first two but still prefixes zero
with "+ "

Can anyone help me.

Paul Smith

 

[Peo Sjoblom]

One way

+General;-General;General

using the general format, you can of course use the same for number formats
with decimals like

+0.00;-0.00;0.00

 

[DDM]

Paul, just add one more section: +0; -0; 0.

DDM
"DDM's Microsoft Office Tips and Tricks"
www.ddmcomputing.com