In an Excel 2007 spreadsheet, if you have long text in a a cell, the text may appear as a line of "#"--it can't fit in the cell. To fix this, take these steps
1. Right click in the cell (or column, etc), and click "format cells."
2. Under "Number," change from Text to General. This is the non-intuitive part that seems to have changed with Office 2007.
3. On the Alignment tab, select "Wrap Text." This is the older part, always been true.
4. You may also need to check that your row hight is not set to a fixed number. From the ribbon, select Format -> Row Height and check.
