Defining positive, negative and zero formats
To define positive, negative and zero formats place a semicolon between the
formats.
Any character can be used to define the sign. For example:
#,###.##;#,###.##-; 0 will output
1,234.56 or
1,234.56- or
0
Any character can be used to define the sign.
#,###.## DR; #,###.## CR; 0
DR will output 1,234.56 DR or
1,234.56 CR or 0
DR
and #,###.##;(#,###.##),
0 will output 1,234.56 or (1,234.56) or 0