How to use custom formatting in MS Excel | How to create custom format in Excel | Learn in 5 Minutes

Показать описание

In this video we will see how to do custom formatting on number or value. In format - custom there is a whole list of pre-defined custom formats available. These formats are constructed using characters like zero, hash, semi-colon, underscore, question mark. So by the end of this video you’ll understand what does each of these characters mean, which will enable you to use the right format knowingly and also you’ll see how to construct your own custom format.

Chapters:
0:00 - Intro
0:45 - Basic Formatting
1:23 - Basics of Custom formatting
1:50 - Understanding custom format constructs
2:53 - Understanding character 0 (Zero)
4:03 - Understanding character # (Hash)
4:55 - Understanding character ? (Question Mark)
6:11 - Understanding character _ (Underscore)
6:30 - Understanding character , (Comma)
7:05 - How to construct custom format.
8:42 - Closure