Turning off microsoft word auto dating
See screenshot: Note: The above two methods cannot work when the number data has been typed already.
When you copy date from other sources to Excel, the date maybe change to text format, or for convinient, you may type date as number string directly, such as 20160504.
This (meaning entering numbers in format NNNN: NN) can be a pain because once Excel has formatted the actual VALUE in the cell has been altered.
If you format back to text you may end up with a number that was not what you entered.
The following VBA function should convert the altered value back to it's original.
In Excel, when you type a string number like “2014-6-1” or “1/2” into a cell, it will auto format this number to date “6/1/2014” or “2-Jan”.
Sometimes, you may think this auto formatting is annoying, now I tell you how to stop auto formatting number to date in Excel.