Currency format in Excel allows you to present numbers as currency amounts, complete with currency symbol, decimal precision and many other formatting options. It can help enhance the appearance and readability of your dataset which is important to clearly understand the data.
In this article, we will explore all the things you need to know about currency format in Excel. We will start the article by explaining how to format numbers as currency in three different ways. Then we will discuss how to customize currency format, change currency symbol, and remove currency format. We will wrap up the article by describing the difference between accounting and currency format.
Download Practice Workbook
Download this practice workbook while reading this article.
How to Format Number as Currency in Excel
1. Use Number Format Dropdown Menu
- First of all, select cells C5 to C14 and go to the Home tab.
- Then click on the number format dropdown and select Currency.
- As a result, the selected cells will be converted to Currency format and the currency symbols will be added.
2. Apply Keyboard Shortcut
- Select the range C5:C14 and press Ctrl+Shift+4 on your keyboard.
- Consequently, the format of the numbers will be changed to Currency.
3. Use Right-Click Menu
- First, Select the cells you want to convert into Currency format.
- Then right-click and select Format Cells.
- In the Format Cells box, select Currency and click on any of the formats of negative numbers.
- Then click on OK.
- As a result, you will get your desired results.
How to Customize Currency Format in Excel
- Select cells C5 to C14 and press Ctrl+1 to open Format Cells options.
- Click on Custom and choose any of the format you want. Besides, you can also write your own custom formula here in the Type: box.
- Finally, press OK to get the output.
How to Change Currency Symbol in Excel
In this section, we’ll show how to change currency symbols in Excel.
- Press Ctrl+1 after selecting the range C5:C14.
- As a result, Format Cells dialogue box will appear.
- Click on the Symbol dropdown and select any symbol as per your need.
- Click on OK and the currency symbol will be changed.
How to Change Default Currency Symbol from Windows Settings
- Click on the windows Start button and select the Settings icon.
- Choose Time & Language settings.
- Then select Region.
- After that, click on Additional date, time & regional settings.
- Then select Change date, time, or number formats to open the Region window.
- In the Region window, select your preferred country under the Format option and press OK.
- Now select cells C5 to C14 and click on the Number Format icon.
- As a result, the numbers will be converted to the default currency format based on your selected region.
How to Remove Currency Format in Excel
- Select the cells with Currency format.
- Then go to the Home tab and click on the dropdown.
- Select General format from the dropdown options.
- Consequently, the currency format will be removed.
Difference Between Accounting and Currency Format
The below table shows the difference between Accounting and Currency Format in Excel.
|Excel Currency Format
|Excel Accounting Format
|Excel Currency format aligns the currency symbol just before the cell value.
|Excel Accounting format aligns the currency symbol near the left edge of the cell.
|Cell values alignment can be changed to left, right or middle alignment.
|Alignment cannot be changed.
|Zero value is displayed like 0.00
|Zero value is displayed with a dash (–) sign.
|Negative values can be shown with a negative sign, parenthesis, in red color etc.
|Negative values can be shown in parenthesis only.
|No space between currency symbol and value.
|Extra spaces between currency symbol and value
Frequently Asked Questions (FAQs)
1. How do you write currency in words?
Excel does not offer any built-in function to convert currency into words. However, it can be done by creating a user-defined function. You will have to create this custom function using VBA code.
2. Can I apply different currency formats to different cells in the same column?
Yes, you can apply different currency formats to different cells in the same column. Simply select each cell individually and then format the cell as any currency you want using the methods explained above.
3. Can I apply conditional formatting based on currency values in Excel?
It is possible to apply conditional formatting based on values in Excel. You can apply conditions based on currency symbols, certain thresholds etc. For instance, you can highlight cells if the amount is higher than the threshold amount or you can color cells depending on the currency symbol.
Things to Remember
- Choose the appropriate number of decimal places based on the selected currency.
- You can add the thousand separators to increase the readability of larger numbers.
Thanks for reading this article. I hope you found this article useful. In this article, we have explored currency format in Excel. We have explained how to format numbers as currency in three different ways. We have also covered how to customize, change and remove currency format in Excel. If you have any queries or recommendations regarding this article, feel free to let us know in the comment section below.
Currency Format in Excel: Knowledge Hub
- Currency With 2 Decimal Places
- Convert Currency to Words
- Convert Currency to a Number
- [Solved]: Currency Format Not Working in Excel