Click the File tab, click Options, and then click the Advanced category. In Excel 2007, click the Microsoft Office Button, click Excel Options, and then click the Advanced category In the When calculating this workbook section, select the workbook you want and then select the Set precision as displayed check box.