MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Data Entry

Posted by Ampleford on August 31, 2001 4:23 AM

This is probably easy, but can I format a cell or a data range in such a way that only "Y" or "N" (or any other characters) can be entered, in that it shows an error message if the user tries to key another character.


Posted by Dax on August 31, 2001 4:26 AM

You can use Validation from the Data menu to specify only certain values for cells.