Allways Display in Caps Letter

[Indhu . K]

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

 

[PJ]

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

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