Any recipes out there for a smart number formatting formula for Google Sheets that's scale-aware, a la Rails ActionView's distance_of_time_in_words method?I would expect to enter a number like: 1,816,724 and see 1.8M (or enter 2,394 and see 2.4K).
Formula for smart, scale-aware number-formatting in Google Sheets? (e.g. 1,024  1k, 1,816,724  1.8M)
google spreadsheets;formulas;formatting;math
The following custom number format mask will produce the desired results without losing the accuracy of the underlying value.[>999999]0.0,,\M;[>999]0.0,\K;0