If I format cells (using the format cells dialog box>Custom) as :
+0;-0
when the value is zero it shows as +0. Is there any way to have negative
numbers as -X, positive numbers as +X and 0 as just 0.
Sandy
Dave Peterson - 23 Feb 2008 23:32 GMT
+0;-0;0
> If I format cells (using the format cells dialog box>Custom) as :
>
[quoted text clipped - 4 lines]
>
> Sandy

Signature
Dave Peterson
Tyro - 23 Feb 2008 23:37 GMT
+0;-0;0
Tyro
> If I format cells (using the format cells dialog box>Custom) as :
>
[quoted text clipped - 4 lines]
>
> Sandy
Sandy - 24 Feb 2008 08:36 GMT
Well that was unanimous :-)
Thanks guys
Sandy
> If I format cells (using the format cells dialog box>Custom) as :
>
[quoted text clipped - 4 lines]
>
> Sandy