From $1,000,000 to $1M

Hi there,

I have a table of numbers going from thousands to billions and want to make more user friendly by abbreviating them. e.g. 1K, 1.5M, 2.5B etc

Any ideas how to do this?

Thanks!

Hi @Robin_Bigio
welcome to Coda Community :handshake:

You can tweak around with formulas order to have an easier formatting:
Have a look if this basic example could help:

Let me know if this goes in your desired direction.
Cheers!

Edit
Thanks @Saul_Garcia for pointing out - and fixing - some inconsistencies.

9 Likes

Worked! Thanks so much!

1 Like