How do i convert a number to a string in excel?
This tutorial shows how to convert number to text in Excel 2016, 2013 and 2010. See how to accomplish the task with the Excel TEXT function and use number to string to specify the formatting. Learn how to change number format to text with the Format Cells… and Text to Columns options. Show
If you use Excel spreadsheets to store long and not so long numbers, one day you may need to convert them to text. There may be different reasons to change digits stored as numbers to text. Below you'll find why you may need to make Excel see the entered digits as text, not as number.
The same issue can occur if the cells are formatted as ZIP code, SSN, telephone number, currency, etc. Note. If you want to convert numbers to words like amount to text, it's a different task. Please check the article about spelling numbers named Two best ways to convert numbers to words in Excel. In this article I'll show you how to convert numbers to text with the help of the Excel TEXT function. If you are not so formula-oriented, have a look at the part where I explain how to change digits to text format with the help of the standard Excel Format Cells window, by adding an apostrophe and employing the Text to Columns wizard. convert-number-to-text-excel-TEXT-function Convert number to text using the Excel TEXT functionThe most powerful and flexible way to convert numbers to text is using the TEXT function. It turns a numeric value into text and allows to specify the way this value will be displayed. It's helpful when you need to show numbers in a more readable format, or if you want to join digits with text or symbols. The TEXT function converts a numeric value to formatted text, thus the result cannot be calculated. If you are familiar with using formulas in Excel, it will not be a problem for you to employ the TEXT function.
Use the Format Cells option to convert number to text in ExcelIf you need to quickly change the number to string, do it with the Format Cells… option.
You'll see the alignment change to left, so the format will change to text. This option is good if you don't need to adjust the way your numbers will be formatted. Add an apostrophe to change number to text formatIf these are just 2 or 3 cells in Excel where you want to convert numbers to string, benefit from adding an apostrophe before the number. This will instantly change the number format to text. Just double-click in a cell and enter the apostrophe before the numeric value. You will see a small triangle added in the corner of this cell. This is not the best way to convert numbers to text in bulk, but it's the fastest one if you need to change just 2 or 3 cells. Convert numbers to text in Excel with Text to Columns wizardYou may be surprised but the Excel Text to Columns option is quite good at converting numbers to text. Just follow the steps below to see how it works.
I hope the tips and tricks from this article will help you in your work with numeric values in Excel. Convert number to string using the Excel TEXT function to adjust the way your numbers will be displayed, or use Format Cells and Text to Columns for quick conversions in bulk. If these are just several cells, add an apostrophe. Feel free to leave your comments if you have anything to add or ask. Be happy and excel in Excel! You may also be interested inHow do I change a number to a string in Excel?Add an apostrophe to change number to text format
If these are just 2 or 3 cells in Excel where you want to convert numbers to string, benefit from adding an apostrophe before the number. This will instantly change the number format to text. Just double-click in a cell and enter the apostrophe before the numeric value.
How do you convert a number to a number as text?Add an apostrophe to change number to text format
Just double-click in a cell and enter the apostrophe before the numeric value. You will see a small triangle added in the corner of this cell.
How do I create a string from a cell in Excel?Here is how to do this:. Select the cells where you have the text.. Go to Data –> Data Tools –> Text to Columns.. In the Text to Column Wizard Step 1, select Delimited and press Next.. In Step 2, check the Other option and enter @ in the box right to it. ... . In Step 3, General setting works fine in this case. ... . Click on Finish.. |