Custom Number Format in Excel 2016 |Number Formatting MasterClass | Free Cheat Sheet download!

Опубликовано: 19 Сентябрь 2024
на канале: Excel Bonanza
30k
454

In this video, I speak about how to create custom number formats in Excel 2016 from A to Z except for date/time formats. I show how to decipher the custom number format codes. The comma, the pound sign, the percentage, and other signs. I show you how to tailor the number format to your needs! There's also a free cheat sheet available on the below link to serve as a reminder for you not to forget how to create your own custom Number format!

*****My online Excel Courses*****


Get your Cheatsheet here:


Links to different parts of the video:
1-Overview of Custom Number formatting:

2- Understanding the different codes:

3-Adding Color:

4-Adding a single Character:

5-Special Characters:

6-Adding Text:

7- The zero "0" Character:

8-The Question Mark "?" character:

9-The Pound " sign:

10-The Asterisk "*" Sign:

11-The Underscore (_) Character:

12-The Comma "," Character:

13-Scientific Numbers - E notations & Exponential values:



Follow us on Social Media:
Facebook:
Twitter:
LinkedIn:
Instagram:
TikTok:
Telegram:
Website: