How to Convert Numbers to Text in Excel ( ln 30 Seconds or Less )
A free Office suite fully compatible with Microsoft Office
Excel is a potent spreadsheet programme used to enter data into cells on various spreadsheets. Users can insert different financial and analytical data into worksheets. Users can enter data, run computations, and conduct actions. Excel spreadsheets function as a database that users may utilise to build dashboards and analytical reports. Although practically all forms of data may be utilised in Excel, numbers are the most often used sort of data. However, there may be circumstances where we must translate numbers to text for a variety of reasons.This article contains multiple step by step methods about how to convert numbers to text in Excel using different functions.
By utilising the VALUE() function, which not only gets rid of the leading zeros but formats the resultant values as General, which has no particular format, you may skip a step. Although it's optional, it's often not essential to take the extra step (shown above) to format the resultant values as numbers.
Attached screen shot below displays the outcome of inputting
duplicating the operation to the remaining cells after moving it to cell C2.
It is common to need to keep the original data. You won't want to change the old values into new ones in such situation. At that point, a straightforward phrase like
=textvalue * 1
comes in useful. The outcome of inserting the phrase is shown in Figure attached below:
transferring it to the other cells by pasting it into cell C2 first.
Text to columns:
Extremely simple to use is the Text to Columns tool. You must reset the format since the values are still text even after the leading zeros have been removed. After selecting the values as previously, carry out the following steps:
Select the Data tab, then select the Text to Columns option under the Data Tools section. By doing this, a wizard opens.
Select Fixed Width from the first pane; there are no delimiters.
Finish is just a click away.
Unfortunately, text is still used to store the values. Do the following with the values chosen:
1.On the Home tab, click.
2.Select Number from the Number Format dropdown menu (in the Number group), as illustrated in screenshot below. You might not want the extra decimal places that this one adds.
3.You may select More Number Formats from the dropdown menu if you don't want those decimal places.
4.From the list of categories, choose Number.
5.The Decimal Places option should be set to 0.
6.To format the chosen values, click OK.
Converting a Number to Text without Scientific Notation Using the TEXT Function:I'll demonstrate how to use the TEXT function in the first approach. A value is converted to text using the function in a predetermined format.Insert the formula shown below in the E5 field to utilise this function.=TEXT(D5,0)Here, D5 is the population's beginning cell in scientific notation, and 0 is the format code that displays all zeros that aren't significant. The output will function as a text because of this.Simply hit ENTER after inputting the formula, then drag down the addition symbol in the E5 cell's lower-right corner (Fill Handle Tool). You'll receive the result right away (E5:E8 cell range).
Did you learn about how to convert number to text in an Excel file? You can follow WPS Academy to learn more features of Word Document, Excel Spreadsheets and PowerPoint Slides.
You can also download WPS Office to edit the word documents, excel, PowerPoint for free of cost. Download now! And get an easy and enjoyable working experience
Was this helpful?
- 1. How to get month name from a date in Excel (3 easy ways)
- 2. How to compare two excel sheets and highlight differences
- 3. Check if value is in list in Excel (3 easy methods)
- 4. How to copy file names in Excel from a folder?
- 5. How to color cell based on value in Excel?
- 6. How to add month name from date in Excel formula