Thousands, Millions, Billions, Oh My! (Custom Excel Formats)
Have you ever wondered how to get Excel to display large numbers nicely? Here are a couple formats that are useful for transforming raw numbers into gigabytes/terabytes and millions/billions. $ format: [>=1000000000]$#,##0.0,,," B";[>=1000000]$#0.0,," M";$#0.0," K" Gbps format: [>=1000000000000]#,##0.0,,,," T";[>=1000000000]#,##0,,," G";General Here's an example: Apply the money format: Now we see: And finally, applying the networking bandwidth format to the "A" column: In this case, I knew I only wanted a few different format types, i.e. gigabytes and terabytes rather than kilobytes and megabytes. Formatting in this way only (per some web research) yields a few different possible formats due to a break-point limitation. For more, "Conditional Formatting" can be used, with formats like: 1000000 #,##0.0,," M" 1000000000 #,##0.0,,," B" 1000000000000 ...