If the cell is too narrow to display the data after you have applied the relevant currency formatting, it will show #. Select the option OK to close the dialog box, Format Cells. This is so because it is a default setting in accounting practices for negative numbers to be displayed in parentheses. It is important to note that in the Accounting number format, the Negative numbers box will not appear. You can also create your own number format if the existing options are not suited to your needs. To display the style for numbers that are negative, go to the Negative numbers box, and select your option. It displays how the changes you have made will affect the display of a number. The digit in the Sample box will change as you apply the changes. That indicates that you do not wish to have any decimal places in the number. Go to the Decimal places box, to input how many decimal places should be included in the number.įor example, if you want to have a figure rounded off, go to the Decimal places box and enter a 0. You should note that in order to show the monetary value without the currency symbol, you must select the option, None. Select the currency symbol of your choice by going to the Symbol box. Go to the Format Cells dialog box and under the Category option select Currency or Accounting. TIP Ctrl+1 is a shorter method to access the Format Cells dialog box. Go to the Home tab, and select the Dialog Box Launcher which is located next to the Number option.
NUMBER FORMAT DIALOG BOX LAUNCHER EXCEL HOW TO
How to change other features of formatting The currency format can be selected an another option by pressing the Ctrl+Shift+$.
NUMBER FORMAT DIALOG BOX LAUNCHER EXCEL SERIES
You can show a number with the original currency sign by selecting the cell or series of cells, and then clicking Accounting Number Format. After highlighting the cell or number of cells and selecting this option you can show a number with the default currency symbol. Go to the Home tab and select the Number group. These options can be found by going to the Home tab and selecting the options from the Number group. This can be achieved by using either the Currency or Accounting format for your data, to the cells that you want to change.
Numbers that should be shown as monetary values must be formatted as currency. Microsoft Office 2016: The Complete Guide (2015) FORMAT NUMBERS AS CURRENCY IN EXCEL 2016