Help

Editing objects, layout parts, and the layout background
F
ILEMAKER PRO HELP 331
Specifying formats for fields containing numbers
You can control how FileMaker Pro displays the values in number fields, calculation fields with
numeric results, and
summary fields.
To specify formats for fields containing numbers:
1. In Layout mode, select one or more fields that display numeric values.
See Selecting objects.
2. Click Inspector in the layout bar, then click Data.
3. In the Data Formatting area, click Number , then select the formats you want to use
from the Format list.
To display numbers Do this
Rounded as needed or expressed
in scientific notation, so the
number fits within the default field
boundaries
For Format, select General.
Exactly as entered (if the value has
more digits than will display in the
field, a ? appears in the field)
For Format, select As entered.
As a Boolean value (a value that is
generally expressed as one of two
values — zero or non-zero)
For Format, select Boolean.
To change the default values, type a new value (up to seven
characters) for Show
non-zeros as and Show zeros as (such
as “Yes” and “No”).
As a decimal number For Format, select Decimal.
• To specify that each value be displayed with the same
number of places, select Fixed number of decimals and
type a value. (A positive value specifies places to the right
of the decimal place, a negative value specifies places to
the left.)
• To specify a unit for a number, type a Symbol to display for
the unit and choose one of the options in the Notation list to
specify where to insert the symbol. Some examples of
symbols are cm (centimeter), km (kilometer), kg (kilogram),
or ft (foot).
• To specify special formatting for negative numbers, in the
Negative area, choose a notation. To display negative
numbers in color (for example, red), choose a color.
• To change the character that separates the whole value of
the number from the fractional part, for Separators, type a
character.
• To include a character to separate every 3 digits, click Use
thousands separator and type a character.
• To include a Kanji separator, click Kanji separator and
choose either the every 4th place or full notation options.