Excel Guides

Precision in Excel

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:

  1. Select the cells that you want to format.
  2. On the Home tab, in the Number group, click the Decrease Decimal button or the Increase Decimal button .

You can also use the following keyboard shortcuts:

  • Ctrl+Shift+~: Apply General number format (displays leading zeros if a number has less than 10 characters, and displays trailing zeros after a decimal point)
  • Ctrl+Shift+!: Apply Comma number format (displays trailing zeros after a decimal point and inserts commas between digit groups)
  • Ctrl+Shift+^: Apply Percent number format (multiplies the cell's value by 100 and displays the result with a percent sign)
  • Ctrl+Shift+#: Apply Date number format (displays dates as mm/dd/yyyy or dddd, mmmm dd, yyyy)
  • Ctrl+Shift+@: Apply Time number format (displays time values as h:mm AM/PM or h:mm:ss AM/PM)

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.