LinkBack URL
About LinkBacks
Hi guys is there any custom formatting so that all Characters inserted in the cell will be CAPITAL only...
ex:- if i enter 123abc it should show 123ABC...
Custom formatting so all input are in CAPITAL
Hi guys is there any custom formatting so that all Characters inserted in the cell will be CAPITAL only...
ex:- if i enter 123abc it should show 123ABC...
Upper and lower cases are NOT formats, so you can't do that. But, you can use this in data validation:
=OR(ISNUMBER(A1),AND(EXACT(A1,UPPER(A1)),ISTEXT(A1)))
to PREVENT lower case text being used.
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
sir your solution is amazing...
but is there no other option...
is there no formating in excel like access...
or any thing else...
I found a micro that helps to change the Case
Please Login or Register to view this content.
So is this now resolved?
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
Not that I am aware of. So data validation, or VBA. Your choice.
ok sir...
thanks for your help...
And it might be very late but CONGRATULATIONS on Becoming a Moderator
Assuming that your data is entered in COLUMN A, when you enter it, lowercase will automatically become uppercase
The code must be placed under your current active worksheet module
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks