View original (French)

Keep uppercase letters in an Excel cell

Solved
PapyDX Posted messages 49 Status Member -  
 Gilles-78 -
Hello,

In Excel, when you type a country name in uppercase and exit the cell, that name is automatically converted to lowercase starting from the second letter!
BELGIUM = Belgium, FRANCE = France...
My problem is that I have a list of names that I want to keep in uppercase, and unfortunately, MARIE-FRANCE becomes MARIE-France!
I assume there is a way to prevent this and keep the title in uppercase... can someone point me in the right direction?
Thank you.

Configuration: Windows 7 / Internet Explorer 8.0

4 answers

  1.
    Mike-31 Posted messages 18405 Registration date   Status Contributor Last intervention   5 147
     
    Hello,

    when you are in Excel, click on the Microsoft button at the top left/then on the Excel OPTIONS button at the bottom right/Section PROOFING/AutoCorrect Options/unclick Correct spelling as you type and OK

    --
    See you +
    Mike-31

    A period of failure is a perfect time to sow the seeds of knowledge.
    29
    1. 4578
       
      20 years I've been wondering how to fix this, thank youuuuuuuu.
      0
    2. Gilles-78
       
      The positions of the buttons have changed, but by relying on the labels, we can easily manage. THANK YOU.
      0