Add Currency Symbol in MS Excel 2013

How to add currency symbol in Microsoft Excel 2013?

Explanation

Currency symbol can be set to the required format using the steps below,
Step 1: Select the cells for which you need to set the currency symbols for the numbers.
Step 2: Right click on the selected cell and click Format Cells.

Step 3: Format Cells dialog box appears, click on the Number tab.
Step 4: Select Currency under the category.
Step 5: Choose the Decimal places for the numbers using the up/down arrows. Click the drop down near the Currency and select the required currency symbol. Click OK.

Values in the selected range of cells is added with the selected currency symbol.

Option 2
Under HOME tab, select Number. Click the drop down near the currency icon and select the required currency format.

Related Topics