ENTER IN ALL CAPS

[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

 

[Peo Sjoblom]

You could use validation, allow custom and a formula like

=EXACT(A1,UPPER(A1))


--


Regards,

Peo Sjoblom

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

 

[sanmanju]

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 -

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

 

[Pete_UK]

Have a look at the code on this site:

http://www.cpearson.com/excel/case.htm

where Chip shows how to do this on data entry.

Hope this helps.

Pete

 

[sanmanju]

Have a look at the code on this site:

http://www.cpearson.com/excel/case.htm

where Chip shows how to do this on data entry.

Hope this helps.

Pete








- Show quoted text -

Thanks Pete,
It works exactly the way I wanted.

Regards
Manju

 

[Pete_UK]

You're welcome. Thanks for feeding back.

Pete