jeudi 26 mars 2020

How to display large numbers in their abbreviated form?

I want to make a number format in Google Sheets that turns large numbers into their abbreviated form. Example: "1 200" -> "1.2k", "1 500 000 000 000 000" (one point five quadrillions) -> "1.5Qa". I have absolutely no idea on how would that look. Thanks in advance.

Aucun commentaire:

Enregistrer un commentaire