Why you SHOULD be USING Custom Number Formatting in Excel

11 months ago
7
how custom formatting works custom formatting basics what is # and 0 in custom format custom formatting syntax hide 0 excel custom formatting add text to number in excel hide zero in excel add text to number format excel XelplusVis custom number format

23 May 2019 Excel Intermediate Functions & Features (For ALL Excel Versions)
‍
Check the Excel Essentials Course: https://courses.xelplus.com/p/learn-excel-essentials

Learn the basics of Excel's custom number formatting and how you can use it for best impact in your reports in this Excel tutorial:
1. The custom formatting rule
2. Practical uses of Excel's custom number formatting
3. How to hide zero values in Excel
4. Custom formatting tricks
5. The proper way to add text to numbers so that values can still be used in formulas

If you have a choice between custom formatting or conditional formatting - always go with custom formatting. Processing times are faster with custom formatting. Conditional formatting is volatile.

⯆ DOWNLOAD the workbook here: https://www.xelplus.com/excel-custom-number-formatting_1/
Many thanks to Michael for writing the detailed blog post and creating the Workbook so we can understand custom formatting better!

LINKS to related videos: Smart uses of custom formatting: https://youtu.be/tGY70sdpaLc
More tricks with custom formatting: https://www.xelplus.com/smart-uses-of-custom-formatting/

★ My Online Excel Courses ► https://courses.xelplus.com

✉ Subscribe & get my TOP 10 Excel formulas e-book for free
https://www.xelplus.com/free-ebook/

EXCEL RESOURCES I Recommend: https://www.xelplus.com/resources/

Get Office 365: https://microsoft.msafflnk.net/15OEg
Microsoft Surface: https://microsoft.msafflnk.net/c/1327040/451518/7593

GEAR
Screen recorder: http://techsmith.pxf.io/c/1252781/347799/5161
Main Camera: https://amzn.to/3a5ldBs
Backup Camera: https://amzn.to/2FLiFho
Main Lens: https://amzn.to/39apgeD
Zoom Lens: https://amzn.to/3bd5pN7
Audio Recorder: https://amzn.to/2Uo5rLm
Microphone: https://amzn.to/2xYy9em
Lights: http://amzn.to/2eJKg1U

More resources on my Amazon page: https://www.amazon.com/shop/leilagharani

Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!

#MsExcel #Excel #LeilaGharani

Loading comments...