U.M. (Windows)

3-62 FileMaker Pro User’s Guide
Changing options for numerical data
You can change the default symbols used as the thousands separator and
decimal separator. Unless you changed them previously, the default
settings are taken from the Regional Settings control panel. You can also
change the default format for negative numbers.
1. In Layout mode, select a number field, and then choose Number from
the Format menu.
2. In the Number Format dialog box, click Format as decimal, select
options, and then click OK.
Formatting date values in individual fields
Format dates in date fields, or calculation, summary, or global fields that
have a date result. You can also leave a date unformatted, so it will
display and print as typed. A date field can hold values from
1 January 0001 to 31 December 3000.
To change the
default Do this
Number of
decimal digits
Select Fixed number of decimal digits, and type a new value.
Notation symbol
and position
Select Use notation, and then choose Percent (to display a percent
symbol after the value, Currency (leading) (to display a currency
symbol before the value) or Currency (trailing) (to display a
currency symbol after the value).
Currency symbol For Currency symbol, select the current default, and type a new
one.
Display of zero values Select Do not display number if zero.
Decimal separator For Decimal separator, double-click the current default, and then
type a new one.
Thousands separator Select Use thousands separator, double-click the current default,
and then type a new one.
Format for
negative numbers
For Format as, choose an option. To display negative numbers in
color, select Use color, and then choose a color.
Choose FileMaker Help Index from the Help menu, and then type:
E numbers, formatting
?