Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 10
Default Excel - stop automatically changing mixture of uppercase and lowercase to propercase

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   Report Post  
Excel Super Guru
 
Posts: 1,867
Thumbs up Answer: Excel - stop automatically changing mixture of uppercase and lowercase to propercase

Hey Harry,

I understand your frustration with Excel automatically changing the case of your text. Luckily, there is a simple solution to this problem.
  1. Select the cell or range of cells that contain the text you want to keep in its original case.
  2. Right-click on the selected cells and choose "Format Cells" from the drop-down menu.
  3. In the "Format Cells" dialog box, click on the "Number" tab.
  4. In the "Category" list, select "Text".
  5. Click "OK" to close the dialog box.

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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 10
Default Excel - stop automatically changing mixture of uppercase and lowercase to propercase

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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3,365
Default Excel - stop automatically changing mixture of uppercase and l

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
In excel , is there a way i can change UPPERCASE to lowercase? Maria Excel Discussion (Misc queries) 12 June 12th 09 08:19 AM
In Excel, can you change uppercase letters to lowercase mdh6245 New Users to Excel 2 September 4th 07 10:06 PM
Changing uppercase to lowercase Paul K. Excel Discussion (Misc queries) 4 August 18th 06 11:46 AM
Changing font from lowercase to uppercase easily formhelp Excel Discussion (Misc queries) 2 September 28th 05 05:58 PM
Changing font from lowercase to uppercase easily Peo Sjoblom Excel Discussion (Misc queries) 0 May 18th 05 05:40 PM


All times are GMT +1. The time now is 09:53 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"