NUMBER FORMAT DIALOG BOX LAUNCHER EXCEL SERIES
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 HOW TO Go to the Home tab, and select the Dialog Box Launcher which is located next to the Number option. TIP Ctrl+1 is a shorter method to access the Format Cells dialog box. Go to the Format Cells dialog box and under the Category option select Currency or Accounting. Select the currency symbol of your choice by going to the Symbol box. You should note that in order to show the monetary value without the currency symbol, you must select the option, None. 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. That indicates that you do not wish to have any decimal places in the number. The digit in the Sample box will change as you apply the changes. It displays how the changes you have made will affect the display of a number. To display the style for numbers that are negative, go to the Negative numbers box, and select your option. You can also create your own number format if the existing options are not suited to your needs. It is important to note that in the Accounting number format, the Negative numbers box will not appear. This is so because it is a default setting in accounting practices for negative numbers to be displayed in parentheses.
Select the option OK to close the dialog box, Format Cells. If the cell is too narrow to display the data after you have applied the relevant currency formatting, it will show #.