Site icon excelwrap

How to add currency symbol in Excel

How to add currency symbol in excel

When you are working with accounting numbers in Microsoft Excel you must format numbers as currency. To display numbers as monetary values, you must format those numbers as currency. Microsoft Excel has a fantastic feature to do this with a click only. If you are searching for how to add currency symbol in Excel your search goes to an end. This content will guide you to add currency symbols in Excel.

For better understanding, I have prepared a small data sheet on the price of rice in different countries which contains three columns named Serial, Country and price. I hope, this will make our tutorial more user-friendly.

Different ways to add a currency symbol in Excel

Using currency format

But if you want to change the default currency symbol in excel to other countries follow the below instructions.

Accounting format to add a currency symbol

We can also use accounting format to add currency symbols. To perform this action please follow the below instructions:

Read More: How to print large excel sheet on one page

Using Custom number format

Read More: How to write vertically in Excel

Keyboard Shortcut to add a currency symbol

You can use the keyboard shortcut to add currency to a cell or range of cells.

Insert a Character symbol to add a currency symbol

It is the most manual method to add a symbol. It is functional to add a currency symbol.

Joining formula with currency symbol

It is also a manual method. It is functional to add a currency symbol.

=”$”&”4.09″

What is the difference between Currency and Accounting format?

Both currency and accounting formats are used to display the monetary values of a cell but still, there are some differences. The difference between the two formats are explained below:

Currency format: The currency symbol appears right next to the first digit in the cell. Decimal places, zero, and negative values are displayed in the below table.

Accounting format: Like currency format, Accounting format is also used for the monetary values of a cell. The currency symbol appears at the start of the cell and numeric values with decimal places at the end. Decimal places, zero, and negative values are displayed in the below table.

how do I remove the currency symbol in Excel

After adding a currency symbol to a cell or a range of cells you may need to remove the currency symbol. No worries, it is a very simple task to do. There are two different ways to do this.

First Method: Format cells method

First Method: From the Number group in the ribbon

Dear Learner, I hope, you already understood how to add currency symbols in Excel reading this content. If you have any queries please make comment below. I will try my best to reply to your comment as soon as possible.

Exit mobile version