samedi 30 octobre 2021

Custom Number Format for Thousands, Millions, Billions, AND Trillions

I've looked everywhere and haven't found any solutions to getting numbers in the "Trillions" to format with a trailing "T".

Here is the custom number format I'm currently using: [<999950]$0.00,"K";[<999950000]$0.00,,"M";$0.00,,,"B"

Which displays these numbers as so:

Trillions

Is Google Sheets also able to make numbers in the Trillions format as $1.00T?

Thanks!

Aucun commentaire:

Enregistrer un commentaire