Master Data Validation in Excel: Force Correct Number of Digits with Custom Formats!

⬇️ Grab the workbook I use in the video here: https://bit.ly/3T1jW6h
In this video tutorial, I’ll show you how to combine a custom number format and data validation to force users to enter the correct number of numeric digits. We will also learn how to combine data validation with functions, like AND() , ISNUMBER() , and LEN()

🎁 Join the FREE COURSE 💥 TOP 30 Excel Productivity Tips: https://bit.ly/3w8yclD

🔔 SUBSCRIBE if you’d like more tips and tutorials like this: https://bit.ly/3HHWQME

🔍 Key Moments in This Video:
00:00 Introduction
00:43 How to determine requirements in Excel
01:35 How to apply a Custom Format in Excel
04:05 Add Data Validation with Functions

🎁 SPECIAL OFFER $9.99 🎓 Join 60,000+ professionals in our courses 👉 https://www.udemy.com/user/andrewex/

🎓 BEST-SELLING COURSES
📖 Excel Dashboard and Data Analysis Masterclass ▶️ https://bit.ly/35lO8OK
📖 Excel Power Query, Power Pivot, Power BI, Power 3D Map & DAX ▶️ https://bit.ly/2qwa2jB
📖 Excel Financial Modeling and Business Analysis Masterclass ▶️ https://bit.ly/3RgKXTq
📖 Microsoft Power BI Desktop Masterclass ▶️ https://bit.ly/3RtTFwm
📖 Excel Macros & Excel VBA Programming for Beginners ▶️ https://bit.ly/2D3Ipkw
📖 Excel Charts, Infographics & Data Visualization Masterclass ▶️ https://bit.ly/2qyosQr
📖 Excel Tips & Shortcuts: 100+ Powerful Hacks for Beginners ▶️ https://bit.ly/2pEMlW8
📖 Python for Absolute Beginners: Learn Python in a Week! ▶️ https://bit.ly/2s1nUTy
📖 Gmail Complete Course: 25+ Google email Techniques ▶️ https://bit.ly/2QCaUxQ

🎬 LINKS to other videos:
Make An INTERACTIVE MAP CHART In Excel 👉 https://youtu.be/-i1LYzuXF88
Make An Excel PANEL CHART 👉 https://youtu.be/UWwma62gUvc
Add Text to Numbers AUTOMATICALLY 👉 https://youtu.be/zW72O13i-TA
Sum Excel Tables in ONE STEP 👉 https://youtu.be/EmbSfFS2n6c
Supercharge Your Spreadsheets with Excel's Goal Seek 👉 https://youtu.be/FZ9pLNvvzFE
Excel SUMPRODUCT Function 👉 https://youtu.be/F0YDTIKRo64
2 WAYS to create Excel Bar & Donut Charts 👉 https://youtu.be/ulpy4B7gz_g
Mastering Excel Pareto Charts 👉 https://youtu.be/xRRs1gUnSF4

📊 Excel Your Skills: www.mellontraining.com

🎁 SHARE this video and spread the Excel love.
Or if you’re short of time, please click the 👍

#excel

Видео Master Data Validation in Excel: Force Correct Number of Digits with Custom Formats! канала Andreas Exadaktylos