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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Trying to create a report that will list unmatched records by Ticket Primary Key 0
Numbered list problem 6
Heading Styles Problem 5
MS Project Overwrites Max. Resource hrs 0
Auto correct going crazy! 1
Word should have bulk auto-correct for speed typing 1
a table in this document has been corrupted... 0
Show/Hide parts of Word 2003 doc with checkboxes 0

Top