Hello,

I am trying to use custom formatting for larger numbers when they happen. I am able to get both $1,200 to show $1.2 K, and then if the cell equals $1,200,000 to show $1.2 M. But I can figure out how to add Billions and Trillions etc. Here is the format I thought would work:

[>=1000000000] $#,##0.0,,," B";[>=1000000] $#,##0.0,," M";[>=1000] $#,##0.0," K";General


It still properly shows Thousands and Millions, but when the cell is a billion + is shows for example $1,200,000,000 --> $1,200 M.

Thanks!