write a data validation rule that would prevent the kind of error that exists in cell U53, so that you do not have to rely on manually identifying such an error and manually correcting it.

Answer rating: 100% (QA)

Data validation is invaluable when you want to share a workbook with others and you want the data entered to be accurate and consistent Among other things you can use data validation for the following ... View the full answer