Notion database properties often contain numeric values such as prices, scores, or progress percentages. By default, these numbers appear as plain digits with no formatting. This makes it hard to read financial data, track completion rates, or compare values at a glance. Notion offers three built-in number formats: Currency, Percent, and Number with a Bar visualization. This article explains what each format does, how to apply them, and what limitations to watch out for.
Key Takeaways: Notion Number Property Formats
- Property Type > Number > Edit Property > Format: Change the display style of any number column to Currency, Percent, or Number.
- Currency format with symbol and decimal places: Adds a currency symbol and controls the number of decimal digits shown.
- Percent format with automatic multiplication: Multiplies the stored value by 100 and appends a percent sign; 0.5 becomes 50%.
- Number format with Bar visualization: Displays a horizontal bar proportional to the value relative to other rows in the same database.
What Each Number Format Does in Notion
Notion number properties store numeric data internally as raw numbers. The format setting only changes how that number is displayed in table, board, and gallery views. The underlying value remains unchanged. This is important because formulas and rollups always use the raw number, not the formatted display.
Currency Format
The Currency format prepends a currency symbol to the number. Notion supports over 30 currencies including USD ($), EUR (€), GBP (£), and JPY (¥). You can also set the number of decimal places from 0 to 10. For example, a raw value of 1234.5 with USD and 2 decimals displays as $1,234.50. The currency symbol and decimal precision apply to every cell in that column.
Percent Format
The Percent format multiplies the stored value by 100 and appends a percent sign. A stored value of 0.25 displays as 25%. A stored value of 1 displays as 100%. You can also set decimal places. This format is useful for progress tracking, survey results, or any ratio. Be careful: entering 25 directly will display as 2500%.
Number Format with Bar
The Number format is the default. It shows the raw value with optional thousand separators and decimal places. The Bar visualization adds a horizontal bar next to each number. The bar length is proportional to the value relative to the highest value in that column. This helps you visually compare magnitudes without reading exact numbers.
Steps to Apply a Number Format to a Property
- Open the database property menu
Hover over the column header of the number property you want to format. Click the down arrow that appears on the right side of the header. Select Edit property from the dropdown menu. - Select the Format option
In the Edit Property panel, locate the Format section. Click the dropdown that currently says Number. A list of three options appears: Number, Percent, and Currency. - Choose Currency and configure symbol and decimals
Select Currency. A new dropdown labeled Currency symbol appears. Choose your desired currency from the list. Below that, set the Decimal places using the number input. Click Done to apply. - Choose Percent and set decimal places
Select Percent. Set the Decimal places value. The percent sign is added automatically. Click Done to apply. - Choose Number and enable Bar visualization
Select Number. Set the Decimal places and toggle Show as bar to on. The bar appears in the table view immediately. Click Done to apply.
Common Mistakes and Limitations of Number Formats
Percent Format Shows Wrong Values
The most frequent mistake is entering a whole number like 50 when you mean 50%. Because Notion multiplies the stored value by 100, entering 50 displays as 5000%. To display 50%, enter 0.5 in the cell. If you already have values entered as whole numbers, you must divide each one by 100 manually or use a formula property.
Bar Visualization Does Not Update After Changing Values
The bar length is calculated based on the maximum value in the column at the time the view loads. If you change a value that becomes the new maximum, bars may not resize until you refresh the page or switch views. This is a display refresh issue. Close and reopen the database tab to force a recalculation.
Currency Symbol Does Not Appear in Formula Results
When a formula property outputs a number, it does not inherit the format of the source property. A formula that references a Currency-formatted column returns a raw number. To show a currency symbol in a formula, use the format() function. Example: format(prop("Price")) + " USD". This returns a text string, not a number, so you cannot use it in further calculations.
Bar Visualization Only Works in Table and Board Views
The Bar visualization appears only in table view and board view. In gallery, list, and calendar views, the bar is not rendered. The number still displays with the chosen format, but the visual bar is hidden.
Number Format Options Compared
| Feature | Number | Percent | Currency |
|---|---|---|---|
| Display example (raw = 0.25) | 0.25 | 25% | $0.25 |
| Thousand separator | Yes (auto) | Yes (auto) | Yes (auto) |
| Decimal places control | 0 to 10 | 0 to 10 | 0 to 10 |
| Symbol selection | None | % only | 30+ currencies |
| Bar visualization | Available | Not available | Not available |
| Works in formulas | Raw value | Raw value | Raw value |
All three formats store the same raw number. The displayed format is purely cosmetic. Formulas, rollups, and filters always use the underlying numeric value, not the formatted text.
You can now apply Currency, Percent, or Number with Bar to any Notion number property. Start by editing the property and selecting the format that matches your data. For financial columns, use Currency and set two decimal places. For completion ratios, use Percent and enter values as decimals. For quick visual comparisons, enable the Bar visualization on a Number column. Remember that formulas do not inherit formatting — use the format() function if you need symbols in formula output.