Custom cell format: "+" for positives numbers ( and of course "-" for negatives )

[roc_on_the_rocks]

I need to use a custom number format (Excel 2003) that adds the "+" sign (w/o the double-quotes) on positive numbers the same way Excel adds "-" sign to negative numbers. I've tried fiddling with it without luck.

Any idea?

Thanks,

 

[DonkeyOte]

Perhaps: +#,##0.00;[red]-#,##0.00;0.00;@

colour optional of course

 

[roc_on_the_rocks]

Thanks a lot DonkeyOte for the speedy and precise anwer. It worked like a charm.