The title pretty much explains it:
In google sheets, if the number in the cell is > 10000 - it should be expressed in kilos.
Else, normally.

Example:
9999 - 9999
11200 - 11 k
312400 - 312 k

CodePudding user response：

If you're happy to use a formula:

=IF(A1>10000, CONCATENATE(INT(A1/1000), " k"), A1)

CodePudding user response：

Within sheets, you can try this custom number formatting.

[>999]0,"k";[<-999]0,"K";0