User manual

Chapter 3 | Creating databases 91
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.
1. In Layout mode, select one or more fields that display numeric values.
2. Click Inspector in the layout bar, then click Data.
3. In the Data Formatting area, click Number .
4. Select the number format you want to use from the Format list, then select additional formats
for the number field.
The options that appear depend on the format you choose.
5. Press Enter or Tab, or click outside the Inspector to apply the changes.
For more information about specifying formats for fields containing numbers, see Help.
Specifying formats for date fields
You can control how FileMaker Pro displays the values in date fields, and calculation fields with
date results.
Important No matter how you format a date field in Layout mode, whenever you click or tab into
the field in Browse mode, FileMaker
Pro displays the date with a four-digit year. FileMaker
recommends that you always enter dates with four-digit years. If you enter dates with two-digit
years, they are converted to four-digit year dates. For more information, see “Conversion of dates
with two-digit years” in Help.
1. In Layout mode, select one or more date fields or calculation fields with a date result.
2. Click Inspector in the layout bar, then click Data.
3. In the Data Formatting area, click Date .
Set options for
currency and
negative values
Choose options for Boolean or
decimal numbers, currency,
and percent
Set options for displaying different
Japanese numeral types