# 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.

## 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.

### 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.

• 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.

## 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 Poor visibility Great visibility

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.

<< Go Back to

## 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 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

Advanced Excel Exercises with Solutions PDF