# How to convert number to text in Excel?

Published on October 13, 2016 by Senthil Kumar

Filed under Excel

rate 1 star rate 2 star rate 3 star rate 4 star rate 5 star
Your rating: none, Average: 2.8 (6 votes)

This article have been viewed 16078 times

In Microsoft Excel 2016 , there are times when you don’t want the numbers present in the cell to be participating in the calculation. This means , you can either update the formula to not include the cell value or else change the number to text.

# How to convert number to text in Microsoft Excel 2016?

You can use the TEXT function in Excel to convert a number to text in Microsoft Excel 2016.

To convert the number to text without using the formatting , use the formula =TEXT(B1,"0") in the cell C1 assuming the cell B1 contains the actual number.

﻿
x

### You might be Interested in these Posts

#### C Program to find the G.C.D of a number using Recursive function

Problem Write a program in C to find the find the G.C.D of a number using recursion and display the ...

#### C Program to print a Half Pyramid using *

Problem Write a program in C to print Half pyramid using * as shown. * * * * * * * * * * ...

#### C Program to display Positive factors of a number

Problem Write a program in C to display all the positive factors of a number enter by the user. Ho...