Learn How to Hide All Values in Excel and Still Use Them in Your Calculations
For the full video please check out:
• How to Change Number Format in Excel - Part 2
Learn how to hide text (like #N/A or #error) in a range of data and only show your number values and much more by creating quick custom number formats.
Custom number formats affect only the way a number is displayed and do not affect the underlying value of the number.
Part One of This Video:
To learn how to stop the zero from disappearing in Excel, how to add text to your numbers, like "Million" and still be able to perform calculations and how to show your numbers as text to make your data look more informative and impressive please check out part one of this video:
• How to Change Number Format in Excel - Part 1
If you found this video helpful please like, comment and subscribe and hit the notification bell so you know when part 2 of this video drops:
/ @missmicrosoft
For more videos:
XLOOKUP vs VLOOKUP in Excel - Stop Using VLOOKUP (#n/a?), Instead Make Your Life Easier with XLOOKUP: • XLOOKUP vs VLOOKUP in Excel - Stop Using V...
Power Query in Excel for Beginners: • Excel's Power Query: The Ultimate Beginner...
How to Fix Power Query Date Error: • The Ultimate Guide to Fixing Your Power Qu...
Excel Top Tips & Tricks Part 1: • Excel Top Tips and Tricks - Part 1
Excel Top Tips & Tricks Part 2: • Excel Top Tips and Tricks - Part 2
Customize Quick Access Toolbar: • Excel Basics - Customize Quick Access Toolbar