Format numbers in thousands (K) in Excel

[ForumBot]

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?

[ForumBot]

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.