Add a number field
- Click + in the upper-right of the title bar.
- Pick Number.
Set number format
- Toggle the thousands separator.
- Display format: integer, decimal, or percentage.
- Pick the thousands and decimal separator styles.
- Abbreviation: shorten very large numbers.
- Toggle disallow negative numbers — when on, negatives can’t be entered.
Display currency
To display currency such as ¥1240.88, use the Currency field type instead.Set a default value
You can set a default number for new records.Inline arithmetic
Number and Currency fields accept simple+ - * / expressions when editing — handy for quick calculations.
Example: four colleagues split a ¥392 lunch — type 392 / 4 in the cell.