This typically happens when I change the view size of a file or cut and paste on an excel spreadsheet I get from a windows user. Any suggestions of what to do to avoid this much appreciated.
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.