It would be nice to be able to optionally specify separate number formats for negative values and zero values, ala Excel and 4th Dimension, and to be able to specify format colors as well. This would allow for the common accounting practice of displaying negative values in parenthesis and/or in red, like “($1,234.56)”, for example.
I might suggest following the MS Excel convention of separating these optional format strings from the primary one using semicolons.
Also, I think that with a format of “#”, the value zero should not display at all, as is common in other languages.
- Amary