Keep uppercase letters in an Excel cell
Solved
PapyDX
Posted messages
49
Status
Membre
-
Gilles-78 -
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
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 réponses
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.
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.
4578
20 years I've been wondering how to fix this, thank youuuuuuuu.
Gilles-78
The positions of the buttons have changed, but by relying on the labels, we can easily manage. THANK YOU.
