Excel - Allow only Text or only Numbers Entered into a Cell in Excel - Custom Formulas

Premium Course: https://www.teachexcel.com/premium-courses/68/idiot-proof-forms-in-excel?src=youtube This tutorial shows you how to limit the entry of data into a cell to only those characters that are numeric or contained within the alphabet. You will be presented with a complex and easily customizable formula that will allow you to determine what a user can enter into a cell, combined with data validation. This tutorial will cover the steps needed to customize the formula and anything else that is required to implement this into a spreadsheet in Excel.