Cell Formatting

  • Thread starter Thread starter Sandy
  • Start date Start date
S

Sandy

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
 
+0;-0;0
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
Click to expand...
 
Back
Top