forcing caps lock

  • Thread starter Thread starter XCESIV
  • Start date Start date
X

XCESIV

I have to setup a spreadsheet but i want to have all the data in the
same format.

Once they complete the data entry sheet the data is displayed on
another spreadsheet. I would like to make everything on this sheet in
capitals letters.

whether it is typed in caps or not.

Can it be done in either the entry sheet that it makes it caps or in
the formula transfering the data

thanks

ps - some cells are text and numbers if that makes a difference.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

forgoten password 4
Formatting in Forms 2
Validate data but then change the entry to upper case 4
Insert "Proper Function" into existing macro 10
From large to small letters 4
formula for changing CAPS to small letters 2
I lose the ability to use the Shift or Caps Lock keys in many websites 12
Swap from all Caps 2

Back
Top