Adding thousand separator in canvas formula

[Saltay]

Hello, how do i add a thousand separator in a canvas formula?

[Paul_Danyliuk]

Hey Saltay, welcome to the community!

You can do that with a hidden formula FormatNumber():

FormatNumber(1680000, true), or FormatNumber(100000, grouping: true) if you’re a fan of named parameters

[Saltay]

omg why is this hidden! thanks!

[Paul_Danyliuk]

Hidden formulas are something that Coda may change or take away at any time. So not really recommended to rely upon. Which in my books means use sparingly and keep an eye on any updates.

More:

A somewhat of a documentation of hidden formulas [Added mechanics of nested buttons]

I was asked to move the list of hidden formulas into a separate post for better readability, so here we go. If you have any tips for using hidden formulas, don’t hesitate to post them below. Disclaimer While hidden formulas are very powerful, they are also experimental. That means that they can crash your document and may be deleted at any point in time without any warning. Index List of hidden formulas (below the index) Diferent types of color arguments How to prevent total destructio…