Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    May 2002
    Location
    Atlanta, Georgia, USA
    Posts
    124
    Thanks
    0
    Thanked 0 Times in 0 Posts

    i vs. I in text format (2000)

    I have a very annoying problem. I have a column of text where I enter a one-letter code (c, i, w). In SOME cells in the column, if I type an i, it "AutoCorrects" to I. Other cells in the column keep the lowercase i.

    I have turned off "Capitalize first letter of sentence" under Tools > AutoCorrect, but this still keeps happening. I can't find any difference between the format of the cells that make this change versus the ones that don't make the change.

    What am I missing? Thanks!

    Bob
    Writing Consultant / Word Template Designer
    Words Connect

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: i vs. I in text format (2000)

    tools - autocorrect
    enter i in replace and you should get to the item:
    replace i with I
    select this line and press <delete><ok>

    Steve

  3. #3
    2 Star Lounger
    Join Date
    May 2002
    Location
    Atlanta, Georgia, USA
    Posts
    124
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: i vs. I in text format (2000)

    Thanks. That seems to have fixed it. I still can't figure out why it only happened in some cells, but not others. There must be some formatting "trigger" that doesn't make sense to me. For example, if I open a blank worksheet (with the "i to I" AutoCorrect entry still in the list) and type i in A1, it turns into I.

    However, if I then type i in A2, it stays i.

    I think in my spreadsheet, I noticed the behavior when I was typing data across a row. So if my single-letter column was G, there was always data in F. It also seems that if I could get the lowercase letter to "stick" in any cell, I could copy it into the appropriate column and then it would stick there.

    Weird!

    At least I know how to get rid of it all together. Thanks!
    Bob
    Writing Consultant / Word Template Designer
    Words Connect

Posting Permissions

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