About Number Formats


Number formats are patterns that Formula One for Java uses for displaying numbers. A date format, for example, might require Formula One for Java to display the data as 3 sets of 2 numbers divided by slashes, for example, 11/11/98. Any date with that format follows that pattern.

Formula One for Java comes with a set of built-in number formats for the basic forms numbers take, such as currency, dates, times, percent values, fractions, and scientific notation. For a list of the built-in number formats, see Built-in Number Formats, by Category.

When you create a worksheet for the first time, by default all cells have the General format applied to them, which means numbers are displayed basically as you enter them. As you begin entering numeric values in the worksheet, Formula One for Java automatically applies some of its built-in number formats based on the characters and numbers you enter and the order you enter them in. For example, if you enter 2/15/64, the slashes and the arrangement of the numbers tell Formula One for Java that this is a date, and the m/d/yy date format is applied. For more information, see How to Enter Constant Values.

If Formula One for Java did not automatically apply the number format you wanted, or if you want to change to a different number format, you can apply a built-in number format to the cell. For information, see Using Built-in Number Formats.

If you don't find the number format you want in the list of built-in number formats, you may create your own number format. For information, see Creating Custom Number Formats.