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

**Read More: **How to Convert Number to Text with Commas in Excel

### 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**. **R****ight-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**

**Download Practice Workbook**

**Related Articles**

- Excel Convert Number to Text with Leading Zeros
- How to Convert Number to Text with Green Triangle in Excel
- How to Convert Number to Text for VLOOKUP in Excel
- Convert Number to Text without Scientific Notation in Excel
- How to Convert Number to Text and Keep Trailing Zeros in ExcelÂ
- How to Convert Number to Text in Excel with Apostrophe

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