Cell to show + sign of a number

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)

 

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.