Precision in Excel is extremely important when working with large amounts of data. By default, Excel rounds numbers to the nearest 10th, 100th, or 1,000th decimal place depending on the number's value. However, you can change the number of decimal places that are displayed for a number without changing the underlying value. This can be useful when you want to make sure that all the numbers in a column line up correctly.
To change the number of decimal places that are displayed for a number, follow these steps:
You can also use the following keyboard shortcuts: