Overview

On October 21, 2025 the new functions formatNumber and splice were added to the Notion Formulas language.

formatNumber

Previously if you wanted to create a display formula to format a number—like taking 1234567890.94 and displaying it as “Revenue: $1,234,567,891”—you’d have to first do the math to round this number and probably do some complicated regular expressions to be able to format the number with commas (see Format dollars with commas).

Display (Regex)

lets(
	/* If true, 20.00 shows as $20, otherwise use decimals ($20.00) */
	simple, true,
	
	/* Number of significant places */
	decimals, 0,
	
	/* First round the amount */
	amount, prop("Number").round(decimals).format(),
	
	/* Split into dollars and cents */
	amounts, amount.contains(".") ? amount.format().split(".") : [amount],
	
	/* Add commas */
	dollars, amounts.at(0).replaceAll("\\B(?=(\\d{3})+(?!\\d))",","),
	
	/* Cents */
	cents, amounts.at(1),
	
	/* Format the return */
	"Revenue: " + ("$" + dollars + (cents.empty() && simple ? "" : "." + cents.padEnd(decimals, "0"))).style("green")
)

IFS Data

Now with formatNumber, this is a bit easier!

Display (formatNumber)

"Revenue: " + formatNumber(prop("Number"), "usd", 0).style("green")

Display (humanize)

formatNumber(prop("Number"), "humanize")

Display (commas)

formatNumber(prop("Number")) /* the default formatter is "commas" */

Untitled

You can see that Display (usd) is significantly shorter than our old regex version. And Display (humanize) gave us a nice friendly version of our billion-dollar revenue (it’s going well this year, clearly).