Excel Magic Trick 433: Custom Number Format for Showing Numbers Rounded to Thousands Position
Loading...
Loading...
1,464
Loading...
Link to this comment:
Share to:
Uploader Comments (ExcelIsFun)
see all
All Comments (8)
-
Look at Conditional Formatting or Custom Number formtting. This video shows both ways:
YTLE#101: Custom Number & Conditional Formatting - Excel
Loading...
- 3:28
Excel Magic Trick 432: Find & Extract Duplicate Recordsby ExcelIsFun6,186 views
- 8:16
Excel Magic Trick 434: Extract Completed Records with Formulaby ExcelIsFun1,992 views
- 5:53
Excel Magic Trick 435: Extract Duplicate Records with Formulaby ExcelIsFun4,759 views
- 6:43
Excel Magic Trick 436: VLOOKUP W 4 Lookup Columnsby ExcelIsFun2,332 views
- 1:45
Excel Magic Trick 437: NETWORKDAYS Function for Counting Workdaysby ExcelIsFun3,237 views
- 1:52
Excel Magic Trick 474: Conditional Format At Every Change In Valueby ExcelIsFun1,903 views
- 1:55
Excel Magic Trick 391: Custom Number Format to Insert Symbol Automaticallyby ExcelIsFun2,943 views
- 1:44
Excel Magic Trick 477: 13 Digit Number ID Shows Scientific Notation!?by ExcelIsFun1,930 views
- 1:36
Excel Magic Trick 456: Add Only Integer Part SUM & INT functionsby ExcelIsFun1,321 views
- 2:58
Excel Magic Trick 448: OFFSET Function To Avoid #REF! Errorby ExcelIsFun4,170 views
- 1:30
Excel Magic Trick 475: SUMPRODUCT for Bank Deposit Calculationby ExcelIsFun1,881 views
- 3:11
Excel Magic Trick 460: Transpose Range with INDEX, COLUMNS and ROWS functionsby ExcelIsFun3,782 views
- 1:40
Excel Magic Trick 523: Fill In Blanks With Custom Number Formatted Numberby ExcelIsFun1,582 views
- 1:47
Excel Magic Trick #201: Custom Number Format For Pro IDby ExcelIsFun2,734 views
- 23:15
Excel Magic Trick 440: Array Formulas Advanced Tipsby ExcelIsFun6,262 views
- 1:42
Excel Magic Trick #503: Custom Number Format For Turnover Ratioby ExcelIsFun2,044 views
- 4:22
Excel Magic Trick 450: Number Formatting Abbreviated Notes (House Paint or Halloween Mask)by ExcelIsFun1,170 views
- 2:51
Excel Magic Trick 441: Count Times That Start With 7 (7:00, 7:15, etc.)by ExcelIsFun1,545 views
- 4:50
Excel Magic Trick 483:Sort sees Date Serial Numbers, Filter Sees Format or Serial Numbersby ExcelIsFun4,119 views
- 3:00
Excel Magic Trick 481: Change Operator in Formula from Drop-Down Using CHOOSE functionby ExcelIsFun2,207 views
So simple but extremly useful. Thanks
teamallan 2 years ago
I am glad that this trick was useful for you!
ExcelIsFun 2 years ago
hi ExcelIsFun thanks for the vid, very interesting!!
are there any other special characters?
that could go without quotes?
denisrapp 2 years ago
Not that I know of. k is the only one that I have used without quotes. All other text, I have put in "quotes".
ExcelIsFun 2 years ago
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.
08505excel 2 years ago
Good point! Formatting does not round a number, it just gives the appearance that is rounded.
ExcelIsFun 2 years ago