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: