Similarly, it's easy to forget to type the currency symbol when you're focusing on the numbers that follow, so using Excel's built-in number format converter is the way forward. Second ...

For that, you need to change the number of zeros after the decimal point accordingly before applying the condition. To show 1000 as 1K in Excel, you can use the formatting condition called #0,”K”.