Jacob Pewitt on 05 Jun 2020 02:28:20
Please enhance the custom number format option to allow for different formats depending on the value of the number being formatted, like you can do in Excel. For example:
[>1000000]0.0,," M";#,##0.0
Which would produce the following formatted results:
1,232,111 -> 1.2 M
5,465 -> 5,465.0