How do you format a number with commas?

Hi there! I have a number like 1000000 that I would like to appear on screen as “1,000,000” - how can I format this number with commas?

Hi!

Sounds like a perfect use case for FORMAT_NUMBER. If you have a number like 1000000, you can use this function as follows:

FORMAT_NUMBER(1000000, ",") 

This will return the string "1,000,000".

Hope that helps!

1 Like