If OneDrive is overwriting files with older versions, set the date and time correctly, reset OneDrive, Pause sync temporarily ...
It’s not easy to fool Excel, but with a few extra clicks, you can work around this odd pasting behavior. If you paste formatted values into a cell with another applied format, the pasted format wins.
Results that may be inaccessible to you are currently showing.
Hide inaccessible results