How to correct a ##### error To make the cell contents smaller, click Home > ... If numbers have too many decimal places, click Home > Decrease Decimal. If dates are too long, click Home > arrow next to Number Format, and pick Short Date.