How can I set the cell to show + sign in a number. eg. 1000 ----> +1000
W whoiswct New member Joined Nov 24, 2012 Messages 57 Reaction score 0 Points 0 Jan 20, 2013 #1 How can I set the cell to show + sign in a number. eg. 1000 ----> +1000
K Kevin@Radstock New member Joined Oct 5, 2012 Messages 52 Reaction score 0 Points 0 Excel Version(s) 365 Jan 20, 2013 #2 Hi whoiswct Something along these lines! Format cells > Number > Custom > Type: "+0;-0" (Not the double quotes)
Hi whoiswct Something along these lines! Format cells > Number > Custom > Type: "+0;-0" (Not the double quotes)
W whoiswct New member Joined Nov 24, 2012 Messages 57 Reaction score 0 Points 0 Jan 20, 2013 #3 Thanks. Can I keep "0" as "0" rather than "+0".
W whoiswct New member Joined Nov 24, 2012 Messages 57 Reaction score 0 Points 0 Jan 20, 2013 #4 I got it by "+###,###,###;-###,###,###;0" Thanks.
Ken Puls Administrator Staff member Joined Mar 13, 2011 Messages 2,531 Reaction score 6 Points 38 Location Nanaimo, BC, Canada Website www.excelguru.ca Excel Version(s) Excel Office 365 Insider Jan 20, 2013 #5 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.
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.