When you paste into Excel from other applications, sometimes the formats can be problematic. Here is a tip to ignore formats.
After you have copied from the other app you can use the second icon on the Paste drop down options to use the destination format, instead of the source format.
This is also available on the right click.
The second icon ignores the source format.