Answer #2
He didn't say that he was copying from Excel!
In fact, if he WAS copying from Excel to Excel,
the default would be to copy  his formatting.
Therefore I conclude that he's copying his "odds" data from another source.
I thought his problem was with autoformating, but
changing it to "none" didn't solve the problem.