Excel keeps driving me nuts by changing things I type in and I have no idea how to stop that.
Right now for example, I have a field where I want to enter the single letter i but it always capitalizes it to I
When I type ii or iii it won’t do that.
I also have a terrible time inserting a - in front of a word. It always changes it into a minus sign, and says the “equation” is undefined!
And this is after I’ve tried all the obvious Format modes, like General or Text.
Also, anything with an @ becomes a live “link” in blue and I can’t even click on the cell to change it without it trying to “execute” the “link”
Format the cells you are using to text - highlight the cells, go to format on the toolbars, then text. The descriptor should say it displays the text exactly as entered.
Ah, and if I’d completely read your post I would have seen that you indicated you already tried that. That’s what I get for skimming.
Umm…I have no idea then.
I dunno, stopping the autocorrect feature from replacing text as you type will prevent it from correcting a lot of other common typos. The reason Excel is changing your lower case i-s to upper case I-s is because there is a default autocorrect rule included in Excel to do so. To delete it, from the TOOLS drop-down menu, choose AUTOCORRECT, then, scroll down on the alphabetical list of default rules until you find "Replace ‘i’ with ‘I’ ", highlight it, and then delete it.
As far as the i-to-I “correction” - what cybersnark said.
For the other problems, put a single quote (’) before the first character of the text you want displayed - that overrides any special meaning that Excel would attach to the hyphen or the @ sign. (The ’ doesn’t actually show up in the cell, only in the Formula bar.)
This doesn’t work in EXCEL, but in WORD. If you have names or words that are all capitals or all lower case or whatever, highlight them and the SHFT-F3 simultaneously allows you to toggle between all caps, first letter capitalized and no capitals.
