Forum Discussion
Ariel_Evan
Feb 18, 2021Copper Contributor
EXCEL CHANGE AUTOMATICALLY TO DATE AND TIME
Hello, I am writing a thesis right now. I really need to copy and paste a lot of data. But the problem is, every time I copy them, Excel always automatically changes some numbers to date and time fo...
peteryac60
Feb 18, 2021Iron Contributor
Hi
Not sure where you are copying the data from (presumably a non-excel file?) - however, if you format the all columns in the receiving excel file before you copy and then when you paste select keep destination format this should work.
Peter