How to Display or Format Number as Currency in Excel 2016 on Windows 10

Microsoft Office Excel 2016 in Windows 10 can be configured to display a number with the default currency symbol. In addition to the options for currency symbol, the format The format has options for the number of decimal places and negative number handling too. The case in point here is how you add a currency symbol before a number in the cells since, simply typing a symbol sign at the beginning of a currency value will not recognised as a number.

number group

Let’s see how to do it.

Format Number as Currency in Excel

Excel users wanting to display numbers as monetary values, must first format those numbers as currency.

To do this, apply either the Currency or Accounting number format to the cells that you want to format. The number formatting options are visible under the Home tab of the ribbon menu, in the Number group.


Next, for displaying a number with the default currency symbol adjacent to it, select the cell or range of cells, and then click Accounting Number Format Button image in the Number group on the Home tab. (If you want to apply the Currency format instead, select the cells, and press Ctrl+Shift+$.)

If you would like to change other aspects of formatting for your selection,

Select the cells you would want to format.

Next, on the Home tab, click the Dialog Box Launcher adjacent to Number. See the screenshot below.

Then, in the Format Cells dialog box, in the Category list, click Currency or Accounting.

Format Number as Currency in Excel

Thereafter, under the Symbol box, click the currency symbol that you want. If you do not wish to display a monetary value, simply chose the None option. If required, enter the number of decimal places that you want for the number.

As you make changes, it will reflect in the number in the Sample box, indicating changing the decimal places affect the display of a number.

Posted by on , in Category Office with Tags
The author Hemant Saxena is a post-graduate in bio-technology and has an immense interest in following Windows, Office and other technology developments. Quiet by nature, he is an avid Lacrosse player. Creating a System Restore Point first before installing a new software, and being careful about any third-party offers while installing freeware is recommended.

One Comment

  1. ravs

    how to remove INR before a number in excel 2016. For example: INR 1000 to 1000.

Leave a Reply

Your email address will not be published. Required fields are marked *

4 + 6 =