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.

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.

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.

How to Make the Dollar Sign to the Right in Excel?. Microsoft Excel 2010 gives you a variety of different ways to automatically format the text and numbers that you place into cells.

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.