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

"Max" wrote in message
...
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

"Bob Phillips" wrote in message
...
+ General;General