Format numbers and currencies on the canvas

1

I am looking to format a number on the canvas : e.g 1000 to 1,000 or 1000 to $1,000.

It seems to work if the number is pulled from a table - it retains the format applied on the table.

Also, how current is the formula list in the help column? I couldn’t find the “FormatPercent” formula there. I found it by browsing the template gallery and found someone using it. Perhaps there is one for the number/currency formats I am looking for.

1 Like
2

to format numbers in the document you can put .tonumber() at the end of the formula… that will put the commas in place where they belong.

as far as the sign goes, you can use concatenate() formula and do something like this concatenate("",sum(1000,1000).toNumber()) and it will give you a dollar amount. There isn’t really a way to format formulas besides doing it manually atm

hope this helps!

1 Like
3

Hi - use can use FormatNumber, FormatCurrency or FormatPercent to do what you are looking for…

3 Likes
4

Dear @mallika

When using the experimental formatCurrency ONLY the most popular currencies are available from the ISO 4217 currency codes.

:question:
Any chance that this these formulas will be officially rolled out, including all ISO 4217 currency codes?

image

3 Likes
5

His is the FormatNumber still working? Can’t find it

6

Yes: just type the formula and it is there to use:

to get: 1,000.00000000000 type:

formatnumber(1000,True(),12

1 Like
7

Thank you, works fine. Don’t know why I couldn’t find it

1 Like