Using Custom Data Validation to ensure accuracy in data capturing:

Data Validationis a Microsoft® Excel® feature that you can use to define restrictions on what data can or should be entered in a cell. In this tip we show you how to use custom data validationto ensure that other people enter the correct type of data in cells, and that they are notified if the data is incorrect. Our example exercise is on ensuring that account codes are captured accurately, that they begin with the standard prefix of ”ACC” and are at least 6 characters long.