Why you SHOULD be USING Custom Number Formatting in Excel

Why you SHOULD be USING Custom Number Formatting in Excel

 

 

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. 

 

Related Topics:

• Convert NUMBERS to WORDS (NO VBA) in Excel 
• Better Excel Presentations: Increase Font Size of Formula Bar 
• VLOOKUP or SUM Not Working? Convert Text to Date? (Excel Text to Columns) 
• 3 Methods to Unhide All Sheets in Excel (and how to hide)