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.
📌 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.
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.
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.
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.
- First, select the cells that you want to modify.
- Then, press Excel keyboard shortcut Ctrl + 1 to open the Format Cells
- 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.
- As a result, you will see that 2 decimal places have been added to the cells in currency format.
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.
Read More: How to Add Currency Symbol in Excel (6 Ways)
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.
- Convert Currency to Words in Excel (with Easy Steps)
- List of Currency Symbols in Excel
- How to Change Currency Symbol in Excel (2 Handy Ways)
- Difference Between Accounting and Currency Format in Excel
- Remove Currency Symbol in Excel (6 Ways)
- How to Concatenate and Keep Currency Format in Excel (3 Methods)