Skip to main content
2 of 3
replaced http://webapps.stackexchange.com/ with https://webapps.stackexchange.com/

Custom Number Format for scale-aware number formatting in Google Sheets (e.g. 1,200→ 1.2k; 1,200,000 → 1.2M; 1,200,000,000 → 1.2B)

Does anyone know a generalized Custom Number Format I can apply in Google Sheets such that numbers appear with it's scale operator and rounded to one decimal place?

Example:

Numbers with Scale Operator1

I looked up a good answer below but I'm not sure how to edit the formula for billions, trillions, and so on.

Short number format in Google Sheets; 1,024 → 1K, 1,816,724 → 1.8M