3

Excel, and I think most Office Products, have an obnoxious habit of replacing regular ASCII characters with obscure extended characters if it can, which renders the result absolutely useless to anything else.

For example, ASCII quotes get replaced with some extended open and close pairs. The thing I'm having trouble with right now is ... is being translated to the single character 0x85. Is it too much to ask that it trust me, not pretend like it knows better what I want, and just leaves my stuff alone? I have better things to do with my time than search&replace the mess that it makes after the fact. There is nothing worse than some programs misguided attempt to make life easier, that ends up making you insane.

Please help me end the pain!

tlum
  • 141

1 Answers1

5

You may apply some control over these auto-corrections via the menu FileOptions, Proofing, AutoCorrect options...

You have four categories under that: AutoCorrect, AutoFormat As You Type, Actions, and Math AutoCorrect.

I suppose that the main option for you is "Replace text as you type":

Enter image description here

harrymc
  • 498,455