– How to Apply Dollar Sign
– How to Change Currency Symbols
– How to Remove Currency Formatting
– How to Apply Accounting Formatting
Currency and accounting are similar, both using dollar signs, but they are different.
In the accounting formatting, dollar sign and the number are even distributed in the cell with the dollar sign on the left, while in the currency formatting, the dollar sign is together with the numbers.
For example, using the numbers below:
Step 1: Apply currency formatting to the numbers, please see here;
Step 2: Apply accounting formatting to the numbers, please see here.