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.

This just tells Excel, in addition to the colors, make the numbers percentages with no decimals. If you want one decimal place, just add it to the number, e.g., 0.0%.

Even if you have the Number format limited to two decimals in Excel, the program remembers a full 15 decimals and will use the fuller number when performing calculations.

Using Excel's number format tool means you can ensure your spreadsheet both looks the part and handles your data exactly how you want it to.

For the same reasons, values formatted with the Accounting number format are also right-aligned by default, though the currency symbol aligns to the left of the cell.