The number formatting engine in Gnumeric is very powerful: it can be used to display numbers in various format as well as providing the user with the ability to specify colors based on various conditions.
Example 3-1 is an example of some of the many variations of formatting one can apply to a number with the preset formats.
Example 3-1. Some examples of number formatting
For the number 600 Numbers General: 600.12 0.0: 600.1 Accounting _($*#,##0_);_($*(#,##0);_($*"-"_);_(@_) $600 _($*#,##0.00_);_($*(#,##0.00);_($*"-"??_);_(@_) $600.12 Scientific 0.00E+00 600.123 |