Cell Formatting

Hi Tad,

Thank you for your question. I've found a solution: Select and right-click the cells containing the numbers, then click "Format cells". In the Category list, select Custom. In the box below "Type", enter the following:

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

This will show K instead of ones, tens and hundreds.

I hope it works for you.

Kind regards
Marius Barnard
Excel Trainer