I've got an Excel 97 worksheet in which I need to validate some cells. No problem, I'll just use Data->Validate, right? Wrong. The built in validation works well enough as long as the user doesn't ...

Data validation in Excel lets you restrict what can be entered into a cell, whether whole numbers, decimals, dates, or a certain number of characters. However, one of the most powerful capabilities of ...