Help

Editing objects, layout parts, and the layout background
F
ILEMAKER PRO HELP 332
4. Press Enter or Tab, or click outside the Inspector to apply the changes.
Notes
• If you specify General format and the field value is a number with 10 or more digits,
FileMaker
Pro displays the number using scientific notation, or rounds the number, or both,
if necessary, to fit within the 10-character maximum for the default field boundaries. When a
number is expressed in scientific notation, you see a decimal number expressed as a power
of 10, for example, 123,456,789,000 could be displayed as 1.2346E+11. If the field value is
a number of fewer than 10 digits, specifying General format produces the same result as
specifying As entered.
• If FileMaker Pro displays a number in a field as a ?, try enlarging the field boundaries in
Layout mode to see the entire value. (When you print a layout with a field that is displaying
a ?, FileMaker
Pro prints as many digits as will fit within the field boundaries and truncates
the other digits.)
• Numbers formatted as decimals are rounded when the number of decimal digits exceeds
the specified fixed number of decimal digits. (For example, if you enter 789.78 and you
specify 3 fixed digits, you see 789.780 in the field; if you specify 0 fixed digits, you see 790;
if you specify -2 fixed digits, you see 800.) However, FileMaker
Pro stores and uses the
unrounded number for calculations and summaries.
As a percentage (FileMaker Pro
multiplies the value by 100 and
displays %)
For Format, select Percent.
Except for Notation, all the other options listed for displaying
numbers as a decimal number are also available when you
select Percent.
As currency For Format, select Currency. You can choose whether the
currency symbol:
• leads before or trails after the value
• appears inside or outside of the negative sign
To change the currency symbol, for Symbol, type a character.
Except for Notation, all the other options listed for displaying
numbers as a decimal number are also available when you
select Currency.
As nothing if the number is zero For Format, select Decimal. Then select Do not display
number if zero.
Using the current system formats
for decimals and thousands
separators
In the Separators area, select System Settings.
FileMaker Pro displays the decimal separator and thousands
separator based on the current system formats when the file is
opened.
When you select this option, the Decimal and Use thousands
separator options are not available.
Using a different Japanese
numeral type (if you’re using a font
that contains Japanese characters)
For Format, select Decimal, Currency, or Percent. Then, for
Numeral type, choose Half-Width, Full-Width, Kanji Numeral
(Modern), or Kanji Numeral.
With different text formatting Select text options using the Appearance tab of the Inspector.
See
Specifying text formats for fields.
To display numbers Do this