Check out this link to Chip Pearson's excellent site for how to do what you
want:

http://www.cpearson.com/Excel/ChangingCase.aspx

"Indhu . K" wrote:

In a cell we may typed in small Letters it should be displays in Caps Letter
only. what are the options otherwise it should be accept only caps Letters