Excel Tip: If You See #### Instead of Numbers

Basic Excel tip: if you're looking at an Excel spreadsheet and instead of seeing numbers you're only seeing ######, it usually means the number is wider than the column .  All you need to do is increase the column width in order to see the number instead.

To fix it...

1. Position your mouse pointer on the right boundary of a column heading until it turns into a double-sided arrow.

2. Drag the boundary until the column is the width that you want, and the number in the cell displays correctly.

For more info on changing columns & rows, read How to Change Column Width and Row Height in Excel 2007.

Topic: