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.

By placing a zero before the decimal, the number is more readily recognized as less than one. By configuring a custom number format you can tell Excel to remove leading zeros.

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%.

If the Excel cell format is not changing to a number because the Number formatting is not working, take these steps to fix the issue.