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

Подписаться 8 тыс.

Просмотров 30 тыс.

50% 1

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****
www.excelbonan...
Get your Cheatsheet here:
bit.ly/2piC6CV
Links to different parts of the video:
1-Overview of Custom Number formatting:
• Custom Number Format i...
2- Understanding the different codes:
• Custom Number Format i...
3-Adding Color:
• Custom Number Format i...
4-Adding a single Character:
• Custom Number Format i...
5-Special Characters:
• Custom Number Format i...
6-Adding Text:
• Custom Number Format i...
7- The zero "0" Character:
• Custom Number Format i...
8-The Question Mark "?" character:
• Custom Number Format i...
9-The Pound "#" sign:
• Custom Number Format i...
10-The Asterisk "*" Sign:
• Custom Number Format i...
11-The Underscore (_) Character:
• Custom Number Format i...
12-The Comma "," Character:
• Custom Number Format i...
13-Scientific Numbers - E notations & Exponential values:
• Custom Number Format i...
Follow us on Social Media:
Facebook: tinyurl.com/25...
Twitter: tinyurl.com/yc...
LinkedIn: tinyurl.com/yc...
Instagram: tinyurl.com/3m...
TikTok: tinyurl.com/p3...
Telegram: tinyurl.com/es...
Website: tinyurl.com/tw...

Опубликовано:

17 окт 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 47

@osoriomatucurane9511 8 месяцев назад

Well Done, time went by, this tutorial still informative

@ExcelBonanza 8 месяцев назад

Thanks, Osorio! I'm glad that you found it useful. I hope it remains evergreen!

@fransvanderwerf7485 Год назад

Happy New Year! Time went by, but this is an excellent video on formatting! Loved how it helped me adding new skill on Excel!

@ExcelBonanza Год назад

Thanks, Frans! I'm glad you liked it! Happy new year to you as well!

@JudgementDAI 7 лет назад

Great job man! Keep it up, a lot of people will find this very useful!

@ExcelBonanza 7 лет назад

Thanks Dean, I really appreciate it :)

@YEBGD 2 года назад

is there a custom format code to turn the numbers from scientific e to x10 for example 7.6E-3 would be 7.6 x10^-3? I have been looking all day long and I can't seem to find it.

@SlametPundya 3 месяца назад

Excellent job!!

@ExcelBonanza 3 месяца назад

Thanks!

@asiasimpson70 4 месяца назад

Loved this video! Thanks!

@ExcelBonanza 4 месяца назад

My pleasure. I'm glad that you found it helpful.

@hubertg7100 2 года назад

Excellent in-depth tutorial, best on the web!

@ExcelBonanza 2 года назад

Thanks, Hubert! I'm glad you liked it

@muhamadfiter8652 4 года назад

Excellent video man ! I have a question, how to change data 111-11111111 output 111-1111 1111 have spasece in four number ?

@islamelzarka 8 дней назад

Thank you so much

@ExcelBonanza 8 дней назад

My pleasure. I'm glad that you found the video helpful.

@nandhagopal8699 4 года назад

Sir how to use comma separator as 100 instead of 1000 i.e I want to display 23,77 instead of 2,377

@jimmyni1983 7 лет назад

Excellent video! Thank you so much! I have bought a dashboard course from you on Udemy platform and I was really a great experience :) Congrats for your excellent job and please keep up helping us to learn valuable Excel! Jimmy from Brazil

@ExcelBonanza 7 лет назад

Hi Jimmy, Thanks for your kind words :) This really helps me keep going :) Stay tuned for more videos to come, and let me know if there's a certain topic that you would like me to create videos about, it would be my pleasure :)

@jimmyni1983 7 лет назад

Hi! A very useful topic wuld be Chart Techniques. The more, the better :)

@ExcelBonanza 7 лет назад

Jimmy1983 sure will do :)