ExcelBanter - Annoying Auto correct

ExcelBanter (https://www.excelbanter.com/)

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - Annoying Auto correct (https://www.excelbanter.com/new-users-excel/58297-annoying-auto-correct.html)

jayceejay

Annoying Auto correct

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

Eddie O

Annoying Auto correct

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

turn off that checkbox.

"jayceejay" wrote:

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

All times are GMT +1. The time now is 04:38 AM.