Excel Mac displays ####'s instead of Values

Have you tried widening the columns it is happening in?

 

There are actually two reasons this can happen.

1. The contents are longer than the column width. There is a setting on the latest version of Excel to auto-size columns. It does not trigger upon paste, unfortunately.

2. The contents are in a mismatched format to what the cell is expecting. If you set the format to "General" the number signs should not appear.

 

If you don't want the column to be wider, you might be able to mess with the text formatting to make it shorter, like removing decimal places, dollar signs, thousands separator, font or font size, etc.