Timeline for Short number format in Google Sheets; 1,024 → 1K, 1,816,724 → 1.8M
Current License: CC BY-SA 3.0
9 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jan 5, 2021 at 11:59 | comment | added | Gabriel | k should be lowercase, M and G uppercase. Uppercase K is for Kelvin. | |
| Feb 8, 2020 at 23:12 | comment | added | Leo Nguyen | Amazing! It's work for me. | |
| Mar 13, 2019 at 15:53 | comment | added | Elad Ratson |
[<999950]0.0,"K";[<999950000]0.0,,"M";0.0,,,"B" this custom formatting is almost perfect. How can numbers up to 999 can be excluded to be represented as is?
|
|
| Mar 5, 2018 at 16:48 | comment | added | Emilio Nicolás | Any workarround for the negative numbers? | |
| Dec 10, 2017 at 6:47 | comment | added | tsujp | Ah, so you cannot have M, K, as well as negative M and negative K in the same one formatting rule. | |
| Dec 10, 2017 at 6:22 | comment | added | user82329 | You can add up to 3 conditions and have one default. | |
| Dec 10, 2017 at 5:36 | comment | added | tsujp | How do you add the K notation for negatives as well? | |
| May 14, 2015 at 22:22 | vote | accept | jm3 | ||
| May 14, 2015 at 8:06 | history | answered | user82329 | CC BY-SA 3.0 |