This question has come up a few times : On our reports and pivot tables, our averages show a long string of decimal points which we would like to eliminate. In design view I can select properties and set decimal points to zero, however when I view the report or pivot table the decimal places remain visible...