# How to Convert Number to Text with 2 Decimal Places in Excel (5 Ways)

Get FREE Advanced Excel Exercises with Solutions!

While working with large Microsoft Excel, sometimes we need to convert numbers to text. We can convert the numbers to text with 2 decimal places. We can easily do that from our dataset. Today, in this article, weâ€™ll learn five quick and suitable ways to convert number to text with 2 decimal places in Excel effectively with appropriate illustrations.

## How to Convert Number to Text with 2 Decimal Places in Excel: 5 Suitable Ways

Letâ€™s consider a situation where we have an Excel worksheet that contains information about different fruits and their price. We will use this worksheet to show how to convert numbers to text with 2 decimal places in Excel. We will use the apostrophe signs (â€˜), Format Cells command, TEXT and IF functions, and VBA macros to convert numbers to text with 2 decimal places. Hereâ€™s an overview of the dataset for todayâ€™s task.

### 1. Use the Apostrophe Symbol to Convert Number to Text with 2 Decimal Places in Excel

The easiest way to convert numbers to text with 2 decimal places in Excel is to insert apostrophe signs (â€˜) in front of the numbers. From our dataset, you have to put an apostrophe sign (â€˜) manually in front of the price of Apple, and while inserting the apostrophe sign (â€˜) in front of the second number and the rest, it will take the apostrophe signs (â€˜) automatically to convert numbers to text with 2 decimal places in Excel. Letâ€™s follow the steps below to learn!

Steps:

• We will put an apostrophe sign (â€˜) in front of each number That will convert the number to text with 2 decimal places.

### 2. Apply the Format Cells Command to Convert Number to Text with 2 Decimal Places in Excel

Another easy way to convert numbers to text with 2 decimal places in Excel is by applying the Format Cells command. It is time-saving also. Letâ€™s follow the instructions below to learn!

Step 1:

• First of all, copy the price of the products by applying the Ctrl + C as the keyboard shortcut from column C and paste those values in column D by using the keyboard shortcut Ctrl + V.

Step 2:

• After that, press Ctrl + 1 simultaneously on your keyboard. A Format Cells dialog box will appear in front of you. From the Format Cells dialog box, firstly, select the Number Secondly, choose Text from the Category box. At last, press OK.

• After completing the above process, you will be able to convert numbers to text with 2 decimal places that have been given in the below screenshot.

### 3. Convert Number to Text with 2 Decimal Places Using the TEXT Function in Excel

The easiest way is to use the TEXT function in Excel to convert numbers to text with 2 decimal places. Letâ€™s see how we can do that.

Step 1:

• First, we will select a cell in the Price column to add decimal points to that cell value. For example, we have selected cell C13.
• Then, we will right-click on that cell. A menu will appear. We will click on the Format Cells from that window.

• A window titled Format Cells will now appear. We will increase the decimal places to 2. Then, we will click on OK.

• We will increase the decimal places to different numbers for different values of the Price.

Step 2:

• Then, we will write the following formula in cell D5.
`=TEXT(C5,"##0.00")`
Formula Breakdown:
• The TEXT function allows you to modify the appearance of a number by using format codes to apply formatting to it.

• After that, simply press ENTER on your keyboard and you will see that the number in cell C5 has been converted to text with 2 decimal places.

• Hence, we will drag the fill handle of cell D5 to apply the formula to the rest of the cells.

• Finally, we will be able to convert all the numbers in the Price column to text with 2 decimal places which have been given in the below screenshot.

### 4. Use the IF Function to Convert Number to Text with 2 Decimal Places in Excel

Alternatively, we can also use the IF function to convert numbers to text with 2 decimal places in Excel. Letâ€™s follow the instructions below to learn!

Steps:

• First of all, we will add decimal points to the cell values in the Price column as we have done in the third method.
• Then, we will write the following formula in cell D5.
`=IF(CELL("FORMAT",C5)="F2", TEXT(C5,"0.00"), TEXT(C5, 0))`
Formula Breakdown:
• IF function will check if the number has 2 decimal points.
• If the number has 2 decimal points, the TEXT function will convert the number to text while keeping those 2 decimal points with the number.
• And if the number does not have 2 decimal points, then the TEXT function will convert the number to text without changing anything.

• Hence, press ENTER on your keyboard and you will be able to convert the number 50 into text 420.50 as the return of the IF function.

• Then, we will drag the fill handle of cell D5 to apply the formula to the rest of the cells.

• Finally, we will see that all the numbers in the Price column have been converted to text with 2 decimal places.

### 5. Run a VBA Code to Convert Number to Text with 2 Decimal Places in Excel

In this method, we will convert numbers to text with 2 decimal places by applying the VBA Code. Applying the VBA code to convert numbers to text with 2 decimal places is the easiest and the time-saving also. Letâ€™s follow the instructions below to learn!

Step 1:

• First of all, select the number range cell C5 to C13, then, from your Developer tab, go to,

Developer â†’ Visual Basic

• After clicking on the Visual Basic ribbon, a window named Microsoft Visual Basic for Applications â€“ Convert Number to Text will instantly appear in front of you. From that window, we will insert a module for applying our VBA code. To do that, go to,

Insert â†’ Module

Step 2:

• Hence, the Convert Number to Text module pops up. In the Convert Number to Text module, write down the below VBA code.
``````Sub Decimal_Places()
Dim R As Range
Set R = Selection
R.NumberFormat = "#,##0.00;-#,##0.00"
End Sub
``````

• After that, run the VBA To do that, go to,

Run â†’ Run Sub/UserForm

• After running the code, you will be able to give the number in a format with two decimal places.

Step 3:

• Now, we will write down the same TEXT formula we have used in method 3 in cell D5 to convert the number in cell C5 to text.

• Upon dragging the Auto Fill handle downward to apply the formula to the rest of the cells, we will see that all the numbers in the Price column have been converted to text with 2 decimal places.

## Things to Remember

ðŸ‘‰ To open the VBA editor Press ALT + F11. You can press ALT + F8 to bring up the Macro window.

ðŸ‘‰ If you do not have a Developer tab, you can make it visible in the following way,

• File â†’ Option â†’ Customize Ribbon

## Conclusion

I hope all of the suitable methods mentioned above to convert numbers to text with 2 decimal places will now provoke you to apply them in your Excel spreadsheets with more productivity. You are most welcome to feel free to comment if you have any questions or queries.

## What is ExcelDemy?

ExcelDemy Learn Excel & Excel Solutions Center provides free Excel tutorials, free support , online Excel training and Excel consultancy services for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Md. Abdur Rahim Rasel

Hi! I'm Md. Abdur Rahim Rasel. Welcome to my Profile. Currently, I am working and doing research on Microsoft Excel and here I will be posting articles related to this. I have completed my graduation in Naval Architecture and Marine Engineering(NAME) from Bangladesh University of Engineering and Technology(BUET). I have a passion for learning new things with my knowledge through perseverance and hard work.

We will be happy to hear your thoughts

Advanced Excel Exercises with Solutions PDF