Number formats in database

Whenever you set a numeric data type for a field in a table, you will need to select which number format to use. Number formats are set on the Format page of the "Format field" dialog (see - Numeric).

There are five number types: Number, Currency, Percent, Fraction, and Scientific. Each of these has an associated set of options, which are displayed and can be set when you click on the relevant number type.

For information on the each of the number types and their associated options, see the following:

Number format

Currency format

Percentage format

Fraction format

Scientific format