Format numbers in thousands (K) in Excel

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.