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