+ Reply to Thread
Results 1 to 3 of 3

Excel auto upper cases certain words even though it was changed to lower case

  1. #1
    Registered User
    Join Date
    09-19-2017
    Location
    Chicago, USA
    MS-Off Ver
    Excel 2013
    Posts
    1

    Excel auto upper cases certain words even though it was changed to lower case

    Hi All,

    I am facing an issue where there is a field in my excel sheet where I want the values to be lower case but excel automatically corrects it to upper case. In case you're wondering, whenever I type "true" or "false" it defaults to "TRUE" and "FALSE". I have tried using the formula "LOWER" to change it and it works temporarily until I save the file, reopen it, and see the fields in upper case again. Additionally, I tried formatting the cell as text and typed everything in lower case but again, it defaults back to upper case upon saving the document. Any idea how to solve this?


    With thanks,
    Paul

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,570

    Re: Excel auto upper cases certain words even though it was changed to lower case

    Use 'true & 'false
    Ben Van Johnson

  3. #3
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,532

    Re: Excel auto upper cases certain words even though it was changed to lower case

    The issue here is that TRUE and FALSE are not strings, they are logical values. If you want to force them to be text, then format the cell as Text (I did what you described above but I could not replicate your results. It worked for me.) or type a single quote before the text, which tells Excel to interpret it as text. You won't see the quote displayed in the cell.

    'true
    'false
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Auto convert lower case to Upper in same cell
    By russkris in forum Excel General
    Replies: 9
    Last Post: 08-08-2014, 06:49 AM
  2. Replies: 7
    Last Post: 04-18-2014, 04:11 PM
  3. [SOLVED] Lower Case to Upper Case but No Auto Correction : Solved by Mod (6StringJazzer)
    By HaroonSid in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 03-27-2014, 10:44 AM
  4. Replies: 2
    Last Post: 08-20-2010, 03:42 AM
  5. [SOLVED] Change the text from lower case to upper case in an Excel work boo
    By dave01968 in forum Excel General
    Replies: 2
    Last Post: 12-09-2005, 05:15 AM
  6. [SOLVED] How do I change a column in Excel from upper case to lower case?
    By Debbie Kennedy in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-02-2005, 02:06 PM
  7. Replies: 1
    Last Post: 03-09-2005, 05:06 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1