Cell to show + sign of a number

whoiswct

New member
Joined
Nov 24, 2012
Messages
57
Reaction score
0
Points
0
How can I set the cell to show + sign in a number.
eg. 1000 ----> +1000
 

Kevin@Radstock

New member
Joined
Oct 5, 2012
Messages
52
Reaction score
0
Points
0
Excel Version(s)
365
Hi whoiswct
Something along these lines!
Format cells > Number > Custom > Type: "+0;-0" (Not the double quotes)
 

whoiswct

New member
Joined
Nov 24, 2012
Messages
57
Reaction score
0
Points
0
I got it by "+###,###,###;-###,###,###;0"
Thanks.
 
Top