PDA

View Full Version : Cell to show + sign of a number



whoiswct
2013-01-20, 08:37 AM
How can I set the cell to show + sign in a number.
eg. 1000 ----> +1000

Kevin@Radstock
2013-01-20, 12:46 PM
Hi whoiswct (http://www.excelguru.ca/forums/member.php?3169-whoiswct)
Something along these lines!
Format cells > Number > Custom > Type: "+0;-0" (Not the double quotes)

whoiswct
2013-01-20, 12:53 PM
Thanks. Can I keep "0" as "0" rather than "+0".

whoiswct
2013-01-20, 12:57 PM
I got it by "+###,###,###;-###,###,###;0"
Thanks.

Ken Puls
2013-01-20, 08:03 PM
Hey whosiwct,

If you're interested in learning the science behind the custom number formats, check out Jon Peltier's article (http://peltiertech.com/Excel/NumberFormats.html) on the subject. He covers it very well.