Number formatting expressions

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