MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Forcing data entered to be in uppercase

Posted by Hock on January 12, 2001 2:00 AM


Is there anyway to force data entered in Excel to be in uppercase?

That is, whether caps lock is on or not, the data in the cells will always be in uppercase. Is this possible?



Posted by Mark W. on January 12, 2001 6:56 AM

Take a look at the Help Topic for "data validation".