The Accounting format displays zeros as dashes and negative numbers in parentheses, whereas the Currency format displays zeros as zeros and denotes negative numbers by using a minus sign (-).The Currency format displays the currency symbol adjacent to the number, whereas the Accounting format displays the symbol at the edge of the cell, regardless of the length of the number.What’s the difference between the two number formats? There are two main differences: The number formatting options are available on the Home tab, in the Number group. To do this, you apply either the Currency or Accounting number format to the cells that you want to format. If you want to display numbers as monetary values, you must format those numbers as currency.
0 kommentar(er)
