How to format formula values on the Canvas

Showcase
1

How to format a formula value added to the Canvas as currency eg. $0,000

  1. Type =
  2. Add 1000 as formula value
  3. Displays the value ok

How to format it as $1,000?

2

Hi @David.Greenwood,

Try with Format("$ {1}",1000)

3

Thanks @Federico_Stefanato

Is there a way to add the ,000 commas eg $1,000 or $100,000 ?

4

Hi @David.Greenwood,

sure: please have a look at this post by @Paul_Danyliuk:

Be aware that FormatNumber() is an experimental formula.

5

Thanks @Federico_Stefanato
I get FormatNumber() works but how to combine that with $ Template?
This does not work

FormatNumber(Format(“${1}”,1000),true)

just returns 1,000

6

Format("$ {1}",FormatNumber(1000, true)) :wink:

7

That’s it! Thanks :slight_smile:

8

If you need currency there, look into FormatCurrency() instead. The currency code would be "USD" then.

That’s another hidden formula fyi.

2 Likes
9

Thanks @Paul_Danyliuk

Be good to get these unhidden! Obviously that’s why I found nothing in help :frowning:

1 Like
10

Thanks @Paul_Danyliuk
Didn’t remember FormatCurrency()

I have to review the list of hidden formulas :wink:

@All Warning:
Not suggested for production use unless you’re aware of it

1 Like
11

Coda now supports formatting for Number, Date and People results, so no more need for FormatCurrency() here!

https://staging.codahosted.io/docs/7fvIGK83Oh/blobs/bl-kJF2dt3JMU/ecdc3c6d3b8298eeef4f6aab9c44309135039b570c225a0a75d24d8af5b7233cac37dd064f77a276571ee7a7ed73bbfb06f1014d3efaf655d82b70b6dd58169e6ce7883587e19bbce25045a19c4266258f30fa3a9c77c44c585a5b42c8f65703f4bd6130(image larger than 10 MB)

2 Likes