Small Capitalisation Problem

[OM]

I want to make up a table of vowel sounds (for teaching my kids), and have a
column with a, e, i, o, u entered. All go in as lower case except i, which
insists as capitalising automatically to I. I've tried formating the cell as
text, but it makes no difference.
As a workaround (just to get the spreadsheet working), I enter "i" as
=LOWER("I"), but I'm sure I shouldn't have to do it this way. I can't find
anything appropriate in the help files.

Any solutions oh wise folk ?

Thanks very much,

Rob Lepper

 

[Dave Peterson]

You can turn off autocorrect.
Tools|Autocorrect Options
and delete the entry for i to I
(This changed will be seen in other office applications, too--it's shared with
word, powerpoint.)

Or you could hit ctrl-z (edit|Undo) to reverse excel's help.

 

[Guest]

If you don't want to completely disable the correction of lone i's to I's...
try this:

Type a lowercase i followed by a space....Excel will capitalize the i
Hold down [ctrl] and press [Z]....to undo the autocorrect, restoring the i
Press [Backspace] one time...to remove the space
Press [enter]

Does that help?
***********
Regards,
Ron

XL2002, WinXP

 

[Gord Dibben]

Note: if i is typed by itself in a cell or with no character following, it does
not capitalize.

a e i works

If typed with a following character Autocorrect will capitalize it.

a e i o u wil return a capital I

Check out Tools>Autocorrect Options.

Remove the "i" from the list.

Or hit CTRL + z after typing the i if you plan to follow it with another
character......a space counts as a character.


Gord Dibben MS Excel MVP

 

[OM]

In my version (2000) of xl, an i typed by itself does change to I, however
having now removed the i -> I autocorrect, everything works as I want it to.
Thank you very much for that.

Rob Lepper