Custom format num > 0 with a "+"

[Max]

How does one custom format numbers > 0 to appear with a preceding "+" (plus
sign) ?
Thanks

 

[Bob Phillips]

+ General;General

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Max]

Thanks Bob. Need a variation ..

Let's say I have 3 numbers below,
currently formatted as: #,##0
(Number format, with thousand separator, to zero dp)

-25,988
21,951
0

I would like to adjust the custom format so that it appears as:

-25,988
+21,951
0

(only numbers > 0 to have the plus sign.
zeros and negative numbers remain as-is)

Thanks

 

[David Biddulph]

+#,##0; -#,##0; 0
--
David Biddulph

Thanks Bob. Need a variation ..

Let's say I have 3 numbers below,
currently formatted as: #,##0
(Number format, with thousand separator, to zero dp)

-25,988
21,951
0

I would like to adjust the custom format so that it appears as:

-25,988
+21,951
0

(only numbers > 0 to have the plus sign.
zeros and negative numbers remain as-is)

Thanks

 

[Max]

Thanks, David. That worked well, and I can see the pattern.