OpenOffice.org does not include presets that use parentheses instead of a minus
sign to denote negative numbers. For financial and accounting purposes,
negatives in parentheses and in red are often the standard. It is also common to
show a centered or offset hyphen instead of a zero to make scanning a
spreadsheet or report easier. Please add the following number formats to the
standard built-in presets:

Number
------
#,##0_);[RED](#,##0);"  -  "
#,##0.00_);[RED](#,##0.00);"  -  "

Percent
-------
#,##0%_);[RED](#,##0%);"  -  "
#,##0.00%_);[RED](#,##0.00%);"  -  "

Currency (using USD as an example)
---------------------------------
[$$-409]#,##0_);[RED][$$-409](#,##0);"  -  "
[$$-409]#,##0.00_);[RED][$$-409](#,##0.00);"  -  "

Ideally, OOo would also supply a "Negative numbers in parentheses" checkbox just
below the "Negative numbers red" checkbox already available.

Please note that there are two spaces before and after the hyphen in the zero
format. This is so that the hyphens display correctly (and pleasingly) whether
the numbers are centered or right-justified.