Become a MacRumors Supporter for $50/year with no ads, ability to filter front page stories, and private forums.

dvbeatty

macrumors newbie
Original poster
May 15, 2011
5
0
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.
 
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.
 
Last edited:
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.
 
Register on MacRumors! This sidebar will go away, and you'll see fewer ads.