Just change the data type of the column in question??

In the article it even mentions this and links to how to change it:

>Excel doesn’t offer the option to turn off this auto-formatting, and the only way to avoid it is to change the data type for individual columns.

https://www.youtube.com/watch?v=SppKiKIdCkI&feature=youtu.be