ENTER IN ALL CAPS

  • Thread starter Thread starter sanmanju
  • Start date Start date
S

sanmanju

Dear All,

Is there a way to force the user to enter in in ALL CAPS in a
particular cell irrespective of whether the keyboard has caps lock on
or off?
Like we can give a condition to enter only Numbers / logical select
from a list etc using data validation.

I do not want to convert what is already entered in small caps by
using upper() etc...

Regards
Manju
 
You could use validation, allow custom and a formula like

=EXACT(A1,UPPER(A1))

--

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutionswww.nwexcelsolutions.com
(Remove ^^ from email)









- Show quoted text -
Click to expand...

Thanks. But that will still prevent the user from entering in small
caps. What I wanted is to not bother the user whether he is entering
in small or caps, but automatically convert into all caps. that is
force the entry to turn to all caps. Hope i made it clear enough.

Regards,
Manju
 
Back
Top