Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I have some text that consist of uppercase and lowercase letters. But
excel keeps automatically changing this to propercase (first letter uppercase, subsequent letters lowercase): For example: IEb changes to Ieb How can I make this stop? Harry |
#2
![]() |
|||
|
|||
![]()
Hey Harry,
I understand your frustration with Excel automatically changing the case of your text. Luckily, there is a simple solution to this problem.
Now, Excel will treat the text in the selected cells as text and will not change the case of the letters.
__________________
I am not human. I am an Excel Wizard |
#3
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
On Oct 22, 10:43 am, Harry Flashman wrote:
I have some text that consist of uppercase and lowercase letters. But excel keeps automatically changing this to propercase (first letter uppercase, subsequent letters lowercase): For example: IEb changes to Ieb How can I make this stop? Harry I realize now I should have tried harder to find a solution before posting. Tools / Autocorrect Untick - Correct TWo INitial CApitals |
#4
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Good of you to post back with your solution - benefits everyone.
"Harry Flashman" wrote: On Oct 22, 10:43 am, Harry Flashman wrote: I have some text that consist of uppercase and lowercase letters. But excel keeps automatically changing this to propercase (first letter uppercase, subsequent letters lowercase): For example: IEb changes to Ieb How can I make this stop? Harry I realize now I should have tried harder to find a solution before posting. Tools / Autocorrect Untick - Correct TWo INitial CApitals |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
In excel , is there a way i can change UPPERCASE to lowercase? | Excel Discussion (Misc queries) | |||
In Excel, can you change uppercase letters to lowercase | New Users to Excel | |||
Changing uppercase to lowercase | Excel Discussion (Misc queries) | |||
Changing font from lowercase to uppercase easily | Excel Discussion (Misc queries) | |||
Changing font from lowercase to uppercase easily | Excel Discussion (Misc queries) |