Excel Magic Trick 433: Custom Number Format for Showing Numbers Rounded to Thousands Position

[ExcelIsFun]

Look at Conditional Formatting or Custom Number formtting. This video shows both ways:

YTLE#101: Custom Number & Conditional Formatting - Excel

[teamallan]

So simple but extremly useful. Thanks

[ExcelIsFun]

I am glad that this trick was useful for you!

[denisrapp]

hi ExcelIsFun thanks for the vid, very interesting!!

are there any other special characters?

that could go without quotes?

[ExcelIsFun]

Not that I know of. k is the only one that I have used without quotes. All other text, I have put in "quotes".

[08505excel]

Title "Custom Number Format for Rounding to" is misleading per EMT#14 formating does not round a number. Using the round function combined with the custom number format to add the k would provide a rounded number that could be used in subsequent formulas. In my opinion.

[ExcelIsFun]

Good point! Formatting does not round a number, it just gives the appearance that is rounded.