I've created an excel file in Excel 2003 for data entry by the bank users and included some validation like max length, drop-down box, etc.
There are certain columns which are mandatory, how can i enforce that a cell is not left blank?
How can i force that data entered is numerical only?
Any help will be greatly appreciated.
Thanks,
Sharath
Bookmarks