Custom format num > 0 with a "+"

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Max - 18 Sep 2007 09:17 GMT

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

Reply to this Message

Bob Phillips - 18 Sep 2007 10:08 GMT

+ General;General

Signature

---
HTH

Bob

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

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

Reply to this Message

Max - 18 Sep 2007 10:42 GMT

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

>+ General;General

Reply to this Message

David Biddulph - 18 Sep 2007 11:02 GMT

+#,##0; -#,##0; 0

Signature

David Biddulph

> Thanks Bob. Need a variation ..
>
[quoted text clipped - 18 lines]
>
>>+ General;General

Reply to this Message

Max - 18 Sep 2007 11:30 GMT

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

> +#,##0; -#,##0; 0

Reply to this Message