Excel text function format codes

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.

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.

• Search by part not by the entire number. For example, you may need to find all numbers that contain 50, like in 501, 1500, 1950, etc.)
• It may be necessary to match two cells using the VLOOKUP or MATCH function.

  However, if these cells are formatted differently, Excel will not see identical values as matching.

  Text functions in excel with examples

• Text functions in excel with examples
• Convert date to text in excel
• Excel convert number to text formula
• Excel convert number to text with leading zeros
• How do i convert numbers to text in excel automatically

For instance, A1 is formatted as text and B1 is number with format 0. The leading zero in B2 is a custom format. When matching these

how to convert date to text in excel
how to convert image to text in excel