The easiest way to apply Accounting is to use the Number Format menu on the ribbon. When you apply the Currency format to a number, the currency symbol appears right next to the first digit in the cell. You can specify the number of decimal places that you want to use, whether you want to use a thousands separator, and how you want to display negative numbers. In the Format Cells dialog box, in the Category list, click Currency or Accounting.
Like the Currency format, the Accounting format is used for monetary values. But, this format aligns the currency symbols and decimal points of numbers in a column. In addition, the Accounting format displays zeros as dashes and negative numbers in parentheses. Like the Currency format, you Continue reading “Format a table”