Cell Formatting

Resolved · Low Priority · Version 2010

Fri 28 Apr 2017, 16:42 Delegate Tad said...

Tad has attended:
Excel Intermediate course
Excel Advanced course
PowerPoint Intermediate Advanced course

Cell Formatting

How can you format,000's as K's

Mon 1 May 2017, 14:48 Trainer Marius said...

RE: 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

Mon 8 May 2017: Automatically marked as resolved.

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Excel tip:

Manually rotating a 3D chart

To manually rotate a 3D chart;
Select the chart (edit mode) and click on one corner of the chart display area. A selection border will appear, using the left mouse button on one of the chart's "corners" (mouse pointer changes to a cross) drag the image which becomes a line representation of the chart (as you begin to drag) and rotate the chart to a view of your choice.
If you dont get it right first time, dont worry, the manoeuver is a little bit tricky.

View all Excel hints and tips