Number formatted

Format Numbers with Commas (Directly in Formulas) - Credit: Thomas Frank’s example

<aside> 💡 If your number is starting out in Number format, and not a String format, convert it to string first before using the formula.

</aside>

It's not obvious at all :) Once you combine numbers with text, you lose all formatting flexibility.

Here's an example with a couple options to simulate number formatting on a string of numbers. One uses Thomas Frank's regex (works up to 1 billion). The other I just tested to see what I could come up with using some array formulas as a learning experiment, and it works for numbers above 1 billion.

https://lifemademore.notion.site/Number-Format-within-Formula-65030260fa904e218049a9a5ff36a707?pvs=4