U.M. (Mac OS)

3-62 FileMaker Pro User’s Guide
Formatting numerical values in individual fields
Format numbers for number fields, or calculation, summary, or global
fields that have a numeric result. You can format a field as a decimal
number or a Boolean number (to produce a true or false result).
A number field can hold up to 255 characters. However, for calculation
purposes FileMaker Pro uses only the first 15 numeric characters.
Adjust the length of the line by changing the width of the field on the
layout, if needed.
1. In Layout mode, select a number field, and then choose Number from
the Format menu.
To format more than one number field at a time, Shift-click each field
to format, and then choose Number from the Format menu.
2. In the Number Format dialog box, select options, and then click OK.
To display numbers Do this
Exactly as typed or
entered
Click Leave data formatted as entered.
As Boolean numbers Click Format as Boolean. To change the default values, type
up to seven characters for Show non-zeroes as and Show
zeroes as (such as True and False).
As decimals Click Format as decimal, and then select options. See the
table in the next section to change default decimal options.
With different text
attributes
Click Text Format, and then select options. (See “Formatting
text attributes in individual fields” on page 3-60.)
Define the symbols
for thousands and
decimal separators
Specify font, style,
size, line spacing,
alignment, and color
Choose options for Boolean
or decimal numbers
Set options for
negative values