Excel Guides

Fixing the Decimal Point in Excel

If you're working with numbers in Excel, you might find that the decimal point is in the wrong place. Maybe you're trying to enter a number like 0.5, but it keeps coming out as 5.0. Or, you might be trying to enter a number like 5, but it keeps coming out as 0.05. Either way, it can be frustrating!

Here's how to fix the decimal point in Excel:

  1. First, open up the Excel file that you're working on.
  2. Then, click on the cell where you're trying to enter the number.
  3. Next, click on the "Format" tab at the top of the screen.
  4. Then, click on "Cells" in the drop-down menu.
  5. A new window will pop up. In this window, click on the "Number" tab.
  6. Under "Category", make sure that "Number" is selected.
  7. Then, under "Decimal places", type in the number of decimal places that you want.
  8. Finally, click on "OK" at the bottom of the window.

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.