#Text disappears in excel how to#

Convert numbers to text in Excel with Text to Columns wizardĬonvert number to text using the Excel TEXT function.Add an apostrophe to change number to text format.Use the Format Cells option to convert number to text in Excel.Convert number to text using the Excel TEXT function.

#Text disappears in excel how to#

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.Ĭonvert-number-to-text-excel-TEXT-function In this article I'll show you how to convert numbers to text with the help of the Excel TEXT function. Please check the article about spelling numbers named Two best ways to convert numbers to words in Excel. If you want to convert numbers to words like amount to text, it's a different task. The same issue can occur if the cells are formatted as ZIP code, SSN, telephone number, currency, etc. That's why their format should be unified. When matching these 2 cells Excel will ignore the leading 0 and will not show the two cells as identical. The leading zero in B2 is a custom format. For instance, A1 is formatted as text and B1 is number with format 0. However, if these cells are formatted differently, Excel will not see identical values as matching.

It may be necessary to match two cells using the VLOOKUP or MATCH function.

For example, you may need to find all numbers that contain 50, like in 501, 1500, 1950, etc.)

Search by part not by the entire number.

Below you'll find why you may need to make Excel see the entered digits as text, not as number.

There may be different reasons to change digits stored as numbers to text. If you use Excel spreadsheets to store long and not so long numbers, one day you may need to convert them to text. Learn how to change number format to text with the Format Cells… and Text to Columns options.

See how to accomplish the task with the Excel TEXT function and use number to string to specify the formatting. This tutorial shows how to convert number to text in Excel 2016, 20.