Accounting formats are used for monetary values, but it aligns the currency symbols and decimal points of numbers in a column
- Select a cell or a range of cells.
- Right-Click, Select “Format Cells“
- Select “Accounting”
Or Press “CTRL + 1” and select “Accounting” Tab
- For the number of decimal places, We can change it from the “Decimal places” box
- From the “Symbol” box, Specify the Currency symbol