Ce site est optimisé pour être consulté depuis un navigateur moderne dans lequel JavaScript est activé.

Format numbers in thousands (K) in Excel

ayi

In MS Excel, I would like to format a number in order to show only thousands and with 'K' in from of it,
so the number 123000 will be displayed in the cell as 123K

It is easy to format to show only thousands (123), but I'd like to add the K symbol in case the number is > 1000.
so one cell with number 123 will display 123
one cell with 123000 will show 123K

Any idea how the format Cell -> custom filters can be used?

ayi

Custom format

[>=1000]#,##0,"K";0

will give you:

Note the comma between the zero and the "K". To display millions or billions, use two or three commas instead.