Forum Discussion
Worst Feature of All Time! -Date Auto Correct-
Hello everyone I apologize beforehand if I start to sound a little angry. I simply want to express my point of view and see if anyone shares the same thoughts or not. The auto correct date function ...
Hi Matthew,
It seems that there is no option to turn off this feature!
By the way, there is an idea in the Excel's suggestion box asking for this, you can vote for it as I did.
For now, you can preset the format of empty cells to Text so that anything you typed will stay as it is.
To do that, select the cells, press Ctrl+1, choose Text from the Category list and then hit OK.
Regards
As of today, March 2023, I find this Excel feature is the most stupid thing MS ever creates. This feature is giving me too many frustration such that I want to throw my laptop into the wall. A simple task of copying 1,000 rows with text format "dd/mm/yyyy" turns into nightmare. A date "02/03/2023" is converted to Feb 3, 2023 on paste while correctly it should be Mar 2, 2023. How stupid is it when I just want to leave the format as it is. WE DONT WANT YOUR HELP ON AUTO CONVERSION. Why do you make it a default and now tell us, you cannot do anything. A creator of something cannot do anything to their own creation? So funny.
