playlistduration

Excel Custom Number Formatting

by excelisfun · 28 videos

Total watch time

3h 26m

at 1× speed · exactly 3 hours, 26 minutes, 3 seconds at 1×

1×3h 26m 3s
1.25×2h 44m 50s
1.5×2h 17m 22s
1.75×1h 57m 45s
2×1h 43m 2s
Average video7m 22s
Longest30m 48s
Shortest1m 39s
Compare Open on YouTube JSON

Plan to finish

About 4 days at an hour a day

Pick a daily pace and the days you'll watch. Ticked videos are skipped.

Days

At one hour a day, every day, this playlist takes about 4 days. Turn on JavaScript to plan around your week.

Videos (28)

3h 26m in total · tick what you've watched

Tick videos you've watched — progress is saved in this browser.

Videos to
Watched
1 Highline Excel 2013 Class Video 30: Custom Number Formatting & Text Functions, (33 Examples) 30:48 2013-11-08
2 Excel Magic Trick 926: Underscore and Custom Number Formatting: Decimals Not Lined Up 9:39 2012-06-19
3 Excel Magic Trick 964: Custom Number Format Show Positive With Plus and Negative With Minus 1:39 2012-08-22
4 YTLE#73: Custom Number Format 00000 2:21 2008-07-30
5 Excel Magic Trick #503: Custom Number Format For Turnover Ratio 1:42 2010-02-08
6 Excel Magic Trick #201: Custom Number Format For Pro ID 1:47 2009-01-09
7 Excel Magic Trick 981: 123.45M From Text To Number, 123,450,000 From Number to 123.45M 3:38 2012-12-20
8 Excel MT142 p1: Custom Number Format & Conditional Formatting for Dates & Weekends 9:52 2008-10-28
9 Excel Magic Trick 930: Mixed Numbers In Formulas: Plus or No Plus, Excel Stills Knows! 3:19 2012-06-22
10 Excel Magic Trick 523: Fill In Blanks With Custom Number Formatted Number 1:40 2010-02-23
11 Excel Magic Trick #502: Excel Date Formatting & Calculations (21 Examples) 24:36 2010-02-09
12 Excel Magic Trick 501: Excel Time Format & Calculations (10 Examples) 13:08 2010-02-05
13 Excel Magic Trick 496: Attendance Sheet with Freeze Pane, IF & SUM functions, Custom Date Formatting 11:35 2010-02-05
14 Excel Magic Trick 483:Sort sees Date Serial Numbers, Filter Sees Format or Serial Numbers 4:50 2010-01-14
15 Excel Magic Trick 433: Custom Number Format for Showing Numbers Rounded to Thousands Position 3:31 2009-11-02
16 Excel Magic Trick 391: Custom Number Format to Insert Symbol Automatically 1:55 2009-09-17
17 Excel Magic Trick #235: Custom Number Format for Inches 3:34 2009-02-02
18 YTL Excel #129: Zip Code, VLOOKUP & TEXT functions 4:40 2008-09-17
19 Highline Excel Class 27: Custom Number Format & TEXT function 26:38 2009-04-27
20 Excel Magic Trick 1067: Displaying Fractional Percent in Excel like: 33 1/3 % or 3/10% 3:56 2014-02-08
21 Excel Magic Trick 1076: Convert Date-Time Values to Serial Numbers w TEXT & Custom Number Format 3:36 2014-02-26
22 Excel Magic Trick 1078: Total Cost Based On Per Minute Charge & Excel Time Values Nearest 15 Seconds 5:50 2014-02-28
23 Excel Magic Trick 1216: Fraction Number Formatting To Show Only Significant Digits, Like: ####/#### 5:26 2015-07-30
24 Excel Magic Trick 1213: Fraction Number Formatting & Making Sure the Correct Number Is Displayed 4:31 2015-07-27
25 Excel Magic Trick 1222: Formula To Add 10kg, 6kg, 19kg: Array Formula Or Custom Number Format? 6:49 2015-08-08
26 Excel Magic Trick 1258: Add Spaces Between Digits: Custom Number Format & TEXT Function 2:19 2016-01-19
27 Excel Magic Trick 1260: VLOOUP Returns Zero when Lookup Table Contains Empty Cell? 3 Fixes. 8:56 2016-01-22
28 Excel Magic Trick 1262: Convert Times Values to HHMM Text or Text HHMM Values to Time Values 3:48 2016-01-24

Embed a badge

Show the watch time in a README or course description — it links back here and updates itself

Watch time: 3h 26m · 28 videos

Markdown
[![Watch time: 3h 26m · 28 videos](https://playlistduration.com/badge/playlist/PLrRPvpgDmw0k3Tjz55OfgvaR0ourukzvG.svg)](https://playlistduration.com/playlist/PLrRPvpgDmw0k3Tjz55OfgvaR0ourukzvG)
HTML
<a href="https://playlistduration.com/playlist/PLrRPvpgDmw0k3Tjz55OfgvaR0ourukzvG"><img src="https://playlistduration.com/badge/playlist/PLrRPvpgDmw0k3Tjz55OfgvaR0ourukzvG.svg" alt="Watch time: 3h 26m · 28 videos" width="203" height="20"></a>

Add ?speed=1.5 to the image URL for the time at that speed, ?label=Course to change the left text, or ?style=flat-square for square corners.

Want the numbers themselves? GET https://playlistduration.com/api/v1/playlist/PLrRPvpgDmw0k3Tjz55OfgvaR0ourukzvG returns them as JSON — free, no key. API docs →

Data from the YouTube Data API as of 2026-09-22 (cached). Private or deleted videos are excluded from totals.