Annoying Auto correct

J

jayceejay

Please HELP. I am entering strings of numbers for street adresses, such as
"137th" or "73rd" and when I advance to the next cell, Excel is automatically
and INCORRECTLY CHANGING these entries to "137Th" and "73Rd". I cannot find
which auto correct feature or other option is doing this to me and it is
driving me crazy. Could someone help me find what I need to shut off?

Jay
 
E

Eddie O

I think it's Tools / Options / Edit / Enable Autocomplete for Cell Values

turn off that checkbox.
 
Top