How to make a custom number formatting for trillions in google sheets

Question

I found this online which formats thousands, millions, and billions

[<999950]0.0,"K";[<999950000]0.0,,"M";0.0,,,"B"

number format sheet

how would you format it so it's by millions, billions, and trillions

Link to sheet

Answer 1

this "internal" formatting is by default able to work with only 3 types of numbers:

• positive (1, 2, 5, 10, ...)
• zero (0)
• negative (-3, -9, -7, ...)

this can be somehow tweaked to show custom formatting like K, B, M but you always got only 3 slots you can use, meaning that you can't have trillions as the 4th type/slot

---

[<999950000]0.0,"M";[<999950000000]0.0,,"B";0.0,,,"T"