Lower case i converted to I?

[Salmon Egg]

I am using a relatively old version of Excel on my relatively new
Macintosh Intel desktop. I am using the latest Leopard software.

I was searching for words containing a lower case "i". When I tried
placing an i into a cell, it gets converted into an upper case "I". Is
this a bug? Have I missed setting some preference? This seems to be the
only lower case letter for which this conversion takes place.

Bill

 

[Pete_UK]

This is probably a setting in Tools | Autocorrect, where common
spelling mistakes are shown against the correct spelling. If you
scroll down the list, you will see lower case i is to be corrected to
upper case I, as i is usually not allowed in normal text.

If you want to stop it being corrected then just deleted it from the
list (although this will also have an effect in Word, which shares the
same list).

Hope this helps.

Pete

 

[Salmon Egg]

This is probably a setting in Tools | Autocorrect, where common
spelling mistakes are shown against the correct spelling. If you
scroll down the list, you will see lower case i is to be corrected to
upper case I, as i is usually not allowed in normal text.

If you want to stop it being corrected then just deleted it from the
list (although this will also have an effect in Word, which shares the
same list).

Hope this helps.

That indeed was helpful. I hate it when software outsmarts itself.

I had worked around this problem by using the character function. In
doing so, I had to use CODE("h") and increment by one to get the
argument for CHAR/

Bill

 

[Pete_UK]

Well, at least you got there, Bill - thanks for feeding back.

Pete

 

[Shane Devenshire]

Hi,

Some info:

In 2007 auto correct will make this correction provided you type a space
after the i. If you just type i and press enter it stays lower case. This
is also true in 2003.

You had a couple of other alternatives to your CHAR(105) solution:

=LOWER("I")

but maybe more useful is to type i space and then press Undo once this will
reverse the Auto Correct action, and then press Enter. This is important
because there are a number of other autocorrect actions that can present the
same problem (c) for example. The three character combination becomes the
copy write symbol.