Combine an Excel custom format with data validation and remove the pressure for input perfection from personnel by letting Excel do the work.

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.

You can even use DOLLAR to convert a number to text format and apply a currency symbol for better data presentation. Similarly, the TEXT function converts a value to text in a specific number format.

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.