1. In Layout mode, select one or more number fields, calculation fields with numeric results, or summary fields.

2. In the Inspector, click the **Data** tab.

3. In the Data Formatting area, click **Number** , then choose a 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 |

Exactly as entered (if the value has more digits than will display in the field, a ? appears in the field) | For |

As a Boolean value (a value that is generally expressed as one of two values—zero or non-zero) | For To change the default values, type a new value (up to seven characters) for |

As a decimal number | For •To specify that each value be displayed with the same number of places, select •To specify a unit for a number, type a •Choose notation and color for negative numbers, change the decimal separator character, and choose a character that separates thousands at every three digits. •To include a kanji separator, click |

As a percentage (FileMaker Pro Advanced multiplies the value by 100 and displays %) | For |

As currency | For |

As nothing if the number is zero | For |

Using the current system formats for decimals and thousands separators | In the FileMaker Pro Advanced displays the decimal separator and thousands separator based on the current system formats when the file is opened. |

Using a different Japanese numeral type (if you're using a font that contains Japanese characters) | For |

With different text formatting | Select text options using the Appearance tab in the Inspector. See Specifying text formats for fields. |

4. Press Enter or Tab, or click outside the Inspector to apply the changes.

•If you specify **General** format and the field value is a number with 10 or more digits, FileMaker Pro Advanced 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 Advanced 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 Advanced 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 Advanced stores and uses the unrounded number for calculations and summaries.

•Only numbers are displayed and printed in a number field formatted as decimal (except for separators and notations specified in the Inspector). To display text and symbols (for example, **@1.98 per pound**) in a number field, select **As entered**. If you use the field in a calculation or summary, only the numeric value is used.

•If you specify the format as** Boolean**, any values in the number field that contain non-numeric data display as blank because they do not contain any numeric content. For example, the value "ABC" would display as blank. However, non-numeric field content returns false in calculations.

Was this topic helpful? Send feedback.