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

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

Steps:

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

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

Step 1:

• Copy theÂ priceÂ of the products and paste in columnÂ D.

Step 2:

• Press Ctrl + 1Â on your keyboard. AÂ Format Cells dialog box pops up. Select NumberÂ and chooseÂ TextÂ from theÂ Category. PressÂ OK.

• Numbers can now be converted to text with 2 decimal places as shown in the image below.

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

Step 1:

• Select a cell in theÂ PriceÂ column to add decimal points to that cell value. We have selected cellÂ C13.
• Right-click on that cell. A menu will appear. Click on Format Cells.

• In the Format Cells window, increase the decimal places to 2. ClickÂ OK.

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

Step 2:

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

• PressÂ ENTER to convert number in cell C5Â to text with 2 decimal places.

• Drag down the fill handle of cellÂ D5Â to apply the formula to the rest of the cells.

• It will convert all the numbers in the Price column to text with 2 decimal places.

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

Steps:

• Add decimal points to the cell values in theÂ PriceÂ column.
• Enter 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.
• If the number does not have 2 decimal points, then the TEXT function will convert the number to text without changing anything.

• PressÂ ENTER to convert.

• Drag the fill handle of cell D5 to apply the formula to the rest of the cells.

• All the numbers in the Price column will be converted to text with 2 decimal places.

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

Step 1:

• Select the number range cellÂ C5Â toÂ C13. From the DeveloperÂ tab, go to,

Developer â†’ Visual Basic

• Click on theÂ Visual Basic ribbon. A window namedÂ Microsoft Visual Basic for Applications â€“ Convert Number to TextÂ pops up. Go to,

Insert â†’ Module

Step 2:

• In theÂ Convert Number to Text module, enter the following VBAÂ code:
``````Sub Decimal_Places()
Dim R As Range
Set R = Selection
R.NumberFormat = "#,##0.00;-#,##0.00"
End Sub
``````

• Run theÂ VBA. To do that, go to,

Run â†’ Run Sub/UserForm

• The numbers will be in a format with two decimal places.

Step 3:

• Enter the TEXTÂ formulaÂ used inÂ method 3Â in cellÂ D5Â to convert the number in cellÂ C5Â to text.

• Drag down the Auto Fill handle.Â All the numbers in theÂ Price column will be converted to text with 2 decimal places.

## Things to Remember

To open theÂ VBA editorÂ PressÂ ALT + F11. PressÂ ALT + F8Â to bring up the Macro window.

If you do not have aÂ DeveloperÂ tab, make it visible by going to:

• File â†’ Option â†’ Customize Ribbon

## Related Articles

<< Go Back to Excel Convert Number to Text | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Md. Abdur Rahim Rasel

MD. ABDUR RAHIM is a marine engineer proficient in Excel and passionate about programming with VBA. He views programming as an efficient means to save time while managing data, handling files, and engaging with the internet. His interests extend to Rhino3D, Maxsurf C++, AutoCAD, Deep Neural Networks, and Machine Learning, reflecting his versatile skill set. He earned a B.Sc in Naval Architecture & Marine Engineering from BUET, and now he has become a content developer, creating technical content... Read Full Bio

We will be happy to hear your thoughts

Advanced Excel Exercises with Solutions PDF