To display 23567 as
23.6K, you can use this custom number format:
Or as pointed out in the comments, depending on your regional settings for the usage of
. use the following format:
You could also display it as
Note the place of the comma. By adding a second comma you can also interpret millions, so 1234567 would be displayed as
The comma works as the thousands separator, and since all the examples have nothing to the right, i.e. no 0 or #, then nothing more is displayed other than the string.
Another very cool example is this:
[<1000000]£##0, "k";[>=1000000]£0.0,," m"
It will show any number in the millions as
£1.2 m, and anything less than a million as
Custom numbers can also be used in charts.