There are few ways to resolve that, the most common and simple one would be to format the cells prior pasting the data as text (select range, right click, format cells, double click on text). What I have done was to simply change the decimal separator: File -> options -> advanced -> untick “use system …
Continue reading “Stop Excel 2013 from auto-converting numeric values to dates”