A quick way to round numbers

Often, you'll store numbers that have several decimal places in cells are formatted to display only one or two decimal places. In these instances, Excel rounds the displayed result. This is usually fine, but you may find that calculations based on the values appear to be off because formulas use the real values, not what you see. Here's a quick and easy way to force Excel to use the values as they appear in the worksheet--but use it with caution. The technique involves using Excel's Precision As Displayed feature, which affects all numbers in the workbook. The conversion is one-way and you won't be able to retrieve the original number value, even if you later disable the Precision As Displayed feature. Depending on how you're using the data, permanently changing the underlying values can have serious implications, so be absolutely sure you understand the impact that altering the data will have on your application. To use the Precision As Displayed feature, choose Tools | Options from the menu bar. Then, click on the Calculation tab, select the Precision As Displayed check box, and click OK. Excel then displays a warning that the change is permanent. Simply click OK to commit the change. Note that this setting change applies only to the currently active workbook.

<<<Back Home Next>>>