LET ME TURN OFF ALL FORMATTING!
JUST LET ME TURN IT ALL OFF. I need to input genes and then run them through a software which I can't if it changes MARCH1 to 3/1 every time without the possibility of turning it off.
Lynn English: Your issue can be solved by removing (C) and (e) from the autocorrect list.
Lynn English commented
I am having to input legislative codes. Many times, these codes include (C) or (e)(4). I cannot type these legislative codes when (C) is automatically reformatted to the copyright symbol, and (e)(4) is reformatted to the Euro symbol! I don't have much time to complete this task, and I don't appreciate wasting it, trying to work around your symbol replacements!
Mary Pat Campbell commented
Re: the gene problem. This made the news in 2016:
It was far more than Charlie having that issue - and even worse, evidently it went undetected for years.
There needs to be some sort of "I know what I'm doing" setting, so that Excel doesn't transform data from the entered type (aka text or digits) into something else entirely. It doesn't need to be the default - after all, many/most Excel users don't know what they're doing - but it would be nice to have as an option so we're not having to repeatedly undo the changes Excel imposed on our entries.
This is about stuff manually entered.
... oh, and that includes column widths. Don't EVER change my column width. I have it set as they are for a reason. I will change it if and when I want. Besides, the reason my number won't fit in my column as it's currently set is because YOU'RE CHANGING THE FORMAT TO WHAT YOU THINK I WANT. Now, not only do I have to undo the format change you entered because you guessed wrong, I also have to go back and reset my column width.
Kenneth Barber's comment might work for the specific incident listed above, but that's just one example of many other times when stuff is changed/reformatted. If I want something formatted, I'll do it myself, thank you. Microsoft, you can't possibly know what I want, and I want you to stop guessing. You think you're being helpful, but your "help" is wasting my time.
Kenneth Barber commented
Make yourself a template that you use for all future files. In this template, for every sheet, select all cells (Ctrl + A or click on the area above row 1's label) and give them the Text number formatting.