Why does excel capitalize true

Regards, Haytham. Greg Daughenbaugh This is a very special situation by the way The solutions provided by Haytham Amairah are great. However you want to treat the different words in the same cell differently!!

Thanks in advance for any help. The code is somehow applied to all columns not only column A! Value Next cell Range "A1". Haytham Amairah Hi Haytham, Am only able to add the data validation to one column. When I add it to the next column, the next column does not work. It only works for the 1st column created. Thank you, Pam. Any ideas? Robyn Johnson. This does not work to automatically change lower to upper case.

It only shows an error telling one that the data is incorrectly entered. It does not change the entry from lower case to upper case automatically. OK Paste as. Treat my content as plain text, not as HTML. Existing Members Sign in to your account. This email is in use. Do you need your password? Submit your solution! When answering a question please: Read the question carefully. Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.

If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome. Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question. Let's work to help developers, not make them feel stupid.

I am not so expert on excel, so just looking for small help. Thanks Satish. You must log in or register to reply here. Similar threads P. Solved VBA: Formating specific text sections of a cell based on conditions. Pquigrafamos Sep 8, Excel Questions 2 3. Replies 25 Views Replies 2 Views Oct 11, MrStarkPH. Replies 3 Views Oct 27, Alex Blakenburg. Solved Why Application. Replies 10 Views Question Vlookup every letter in a text string. Isaactd Mar 3, Excel Questions.

Replies 5 Views Mar 5, GlennUK. The apostrophe tells Excel that you want that entry to be explicitly evaluated as a text string. Thread Tools. Smilies are On. Trackbacks are On. Pingbacks are On. Refbacks are On.

The time now is PM. The comments are property of their posters. About Us "It's about Microsoft Excel".