Currency Format in Excel (Format, Change & Remove)

Get FREE Advanced Excel Exercises with Solutions!

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.

Format Number as Currency


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.

Convert Values to Currency

Format Number as Currency


2. Apply Keyboard Shortcut

  • Select the range C5:C14 and press Ctrl+Shift+4 on your keyboard.

Apply Keyboard Shortcut to Format Number as Currency

  • Consequently, the format of the numbers will be changed to Currency.

Numbers Formatted to Number as Currency


3. Use Right-Click Menu

  • First, Select the cells you want to convert into Currency format.
  • Then right-click and select Format Cells.

Use Right-click Menu to Format Number as Currency

  • In the Format Cells box, select Currency and click on any of the formats of negative numbers.
  • Then click on OK.

Choose Negative Number Format

  • As a result, you will get your desired results.

Numbers Formatted as Currency


How to Customize Currency Format in Excel

  • Select cells C5 to C14 and press Ctrl+1 to open Format Cells options.

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.

Choose Custom Format

  • Finally, press OK to get the output.

Customize Currency Format


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.

Open Format Cells Options

  • As a result, Format Cells dialogue box will appear.
  • Click on the Symbol dropdown and select any symbol as per your need.

Select a Currency Symbol

Change Currency Symbol


How to Change Default Currency Symbol from Windows Settings

  • Click on the windows Start button and select the Settings icon.

Open Windows Settings

  • Choose Time & Language settings.

Open Time & Language Settings

  • Then select Region.

Click on Region

  • After that, click on Additional date, time & regional settings.

Go to Additional Region Settings

  • Then select Change date, time, or number formats to open the Region window.

Launch Region Settings

  • In the Region window, select your preferred country under the Format option and press OK.

Change Region Format

  • Now select cells C5 to C14 and click on the Number Format icon.

Click on Number Format Icon

  • As a result, the numbers will be converted to the default currency format based on your selected region.

Change Deafault Currency Settings


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.

Remove Currency Format

  • Consequently, the currency format will be removed.

Currency Format 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
Poor visibility Great visibility

Currency Format vs Accounting Format


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.

Conclusion

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


<< Go Back to Number Format | Learn Excel

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Alif Bin Hussain
Alif Bin Hussain

Alif Bin Hussain earned a BSc in Civil Engineering from Bangladesh University of Engineering and Technology. As an engineering graduate, he has a deep passion for research and innovation. He loves to play with Excel. In his role as an Excel & VBA Content Developer at ExcelDemy, he not only solves tricky problems but also shows enthusiasm and expertise in handling tough situations with finesse, emphasizing his dedication to delivering top-notch content. He is interested in C, C++,... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo