If you want to remove the currency formatting, you can follow these steps to reset the number format. You can also drag the right boundary until the columns are the size that you want. This automatically resizes the column to fit the number. To expand the column width, double-click the right boundary of the column that contains the cells with the # error. If Excel displays # in a cell after you apply currency formatting to your data, the cell probably isn't wide enough to display the data. 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.
Excel for Microsoft 365 Excel for Microsoft 365 for Mac Excel 2021 Excel 2021 for Mac Excel 2019 Excel 2019 for Mac Excel 2016 Excel 2016 for Mac Excel 2013 Excel 2010 Excel 2007 Excel for Mac 2011 More.