Currency with 2 Decimal Places in Excel (with Quick Steps)

If you are searching for the solution or some special tricks to apply Currency format with 2 decimal places in Excel then you have landed in the right place. There is a quick way to apply the Currency format with 2 decimal places in Excel. This article will show you each step with proper illustrations so, you can easily apply them for your purpose. Let’s get into the main part of the article.


Download Practice Workbook

You can download the practice workbook from here:


Steps to Apply Currency with 2 Decimal Places in Excel

Suppose, you have an employee dataset that contains the designation, years of service, and salary. But salaries are in Number format and you want to convert them to currency format with 2 decimal places. In this section, I will show you a quick and easy method to apply Currency format with 2 decimal places in Excel on Windows operating system. You will find detailed explanations of methods and formulas here. I have used Microsoft 365 version here. But you can use any other versions as of your availability. If any methods won’t work in your version then leave us a comment.

📌 Step 1: Select the Cells

First, you have to select the cells which are in Number format now but have to convert them into the Currency format. So, in this dataset, you have to select the cells E5:E10.

Select the Cells

Read More: Excel VBA: Format Currency to Two Decimal Places (3 Methods)


📌 Step 2: Apply Currency Format

After selecting the cells, go to the Home tab. In the Number section, click on the “$” icon which will convert the numbers to Currency format.

Apply Currency Format

Alternatively, you can select the Currency format in the Number Section. For this, click on the drop-down arrow and select the option “Currency” to apply this format to the selected cells.

Apply Currency Format

As a result, you will see the numbers in the salary column are converted to the Currency format. By default, the currency format contains two decimal places. But if you see there are no decimal places or any other digits except 2 then, you have to change the Currency format. For this, follow the next section.

Currency with 2 Decimal Places in Excel

Read More: How to Change Default Currency in Excel (4 Simple Methods)


Applying Currency Format Not Generating 2 Decimal Places Automatically

Sometimes you may see that the currency format values are not containing 2 decimal digits. Then, you have to apply decimal places manually to the selected cells. Follow the solution for this.

Solution:

  • First, select the cells that you want to modify.
  • Then, press Excel keyboard shortcut Ctrl + 1 to open the Format Cells

When Currency Format Is Not with 2 Decimal Places Automatically

  • In the Format Cells window, go to the Currency
  • Here, you will see an option named “Decimal Places”.
  • Insert 2 in this box to add 2 decimal places with currency format.

Currency with 2 Decimal Places in Excel

  • As a result, you will see that 2 decimal places have been added to the cells in currency format.

When Currency Format Is Not with 2 Decimal Places Automatically

Alternatively, you can add decimal places from any format of numbers. For this, first select the cell then, click on the “Increase Decimal” button to increase the decimal places after the point, and click on the “Decrease Decimal” button to remove decimal digits in the numbers.

When Currency Format Is Not with 2 Decimal Places Automatically

Read More: How to Add Currency Symbol in Excel (6 Ways)


Conclusion

In this article, you have found how to apply Currency format with 2 decimal places in Excel. I hope you found this article helpful. You can visit our website ExcelDemy to learn more Excel-related content. Please, drop comments, suggestions, or queries if you have any in the comment section below.


Related Articles

Osman Goni Ridwan

Osman Goni Ridwan

I am Ridwan, graduated from Naval Architecture and Marine Engineering Dept, BUET, currently residing in Dhaka, Bangladesh. And my passion is to grow up my skillsets with industry demands. My prime goal is to be a data analyst as I do love to solve problems and play with data.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo