Skip to main content
edited tags
Link
pnuts
  • 17.8k
  • 5
  • 54
  • 103
Bumped by Community user
Bumped by Community user
Bumped by Community user
replaced http://webapps.stackexchange.com/ with https://webapps.stackexchange.com/
Source Link

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

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

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

Tweeted twitter.com/StackWebApps/status/848946184639197184
Source Link

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