Cell to show + sign of a number

[whoiswct]

How can I set the cell to show + sign in a number.
eg. 1000 ----> +1000

[Kevin@Radstock]

Hi whoiswct
Something along these lines!
Format cells > Number > Custom > Type: "+0;-0" (Not the double quotes)

[whoiswct]

Thanks. Can I keep "0" as "0" rather than "+0".

[whoiswct]

I got it by "+###,###,###;-###,###,###;0"
Thanks.

[Ken Puls]

Hey whosiwct,

If you're interested in learning the science behind the custom number formats, check out Jon Peltier's article on the subject. He covers it very well.