Site icon ExcelNotes

How to Apply Accounting Formatting

– How to Apply Dollar Sign
– How to Change Currency Symbols
– How to Remove Currency Formatting
– Difference between Currency and Accounting

In Excel, you can add dollar sign in two way: currency formatting and accounting formatting. Currency formatting is currency signs and numbers together, while accounting formatting is currency signs left aligned and numbers right aligned. Please follow the steps below to apply accounting formatting:

Step 1: Select cells or the data range with numbers;

Step 2: Click the "Home" Tab from Ribbon;

Step 3: Click "Accounting Number Format" from the command list;

Alternatively, select "Accounting" from the "Number Format";

Step 4: The dollar signs are added to the numbers in the accounting formatting.

Exit mobile version