Convert Numbers to Text in Excel
Excel generally displays all text values aligned on the left and numeric values aligned in right.
![text and number format](https://overallmoney.com/wp-content/uploads/2022/03/text-number-1.png)
Below are a few examples to convert numbers to text format.
Example-1
Select range C3:C7 and change the cell format style to Text.
![text format in excel](https://overallmoney.com/wp-content/uploads/2022/03/number-text1.png)
Example-2
Type in an apostrophe right before a number. It will turn into Text and the cell containing it will have a little green triangle around the corner.
![apostrophe](https://overallmoney.com/wp-content/uploads/2022/03/number-text2.png)
Example-3
Use the TEXT function to convert a numeric value to a text value. Write the following function in cell C3.
=TEXT(B3,”#,###0.00″)
![text function in excel](https://overallmoney.com/wp-content/uploads/2022/03/number-text3.png)
6 of 14 finished! Recommending more on Format Cells: Next Example >> |
<< Previous Example | Skip to Next Chapter 05: Formulas and Functions Basics |