Learn how to automatically insert decimal points in Excel spreadsheets using Excel Options, Registry Editor orl Group Policy Editor.

This tutorial will show you how to change the number of Decimal places in Microsoft Excel using any one of these 3 methods.

Warnings Excel will only produce binary numbers with up to 10 bits. This means that it can only convert decimal numbers greater than -513 and less than 512.

How to Get Decimals to Line Up in Excel. If you're using Excel to calculate monetary values, then you only have to worry about two decimal places in your numbers.