To close the Format Cells dialog box, click OK. That's because it is standard accounting practice to show negative numbers in parentheses. Note: The Negative numbers box is not available for the Accounting number format. On the Home tab, click the Dialog Box Launcher next to Number. If you want more control over either format, or you want to change other aspects of formatting for your selection, you can follow these steps. (If you want to apply the Currency format instead, select the cells, and press Ctrl+Shift+$.) You can display a number with the default currency symbol by selecting the cell or range of cells, and then clicking Accounting Number Format in the Number group on the Home tab. What's the difference between the Currency and Accounting formats?Ĭreate a workbook template with specific currency formatting settings 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 Comments
Leave a Reply. |