Re: Display plus sign

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Andy (Andy_at_nospam.net)
Date: 09/22/04 

Date: Wed, 22 Sep 2004 05:05:34 GMT

What Mike said:

> Try some variant of +#,###_);(#,###)

I learn something every time I come here. So the first format is for
positive numbers and the second is for negative.

 +#,##0;-#,##0

entered in FormatCells > Custom does what you want, "+" for positive
numbers and "-" for negative numbers