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:
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.8MShort number format in Google Sheets; 1,024 → 1K, 1,816,724 → 1.8M