The result is the number 1021 formatted as text “1021”. All numbers in column D are formatted as text with the formulas seen in column F.

Convert with formatting

The TEXT function can be used to convert numbers to text using a given number format. In the example shown, the TEXT function is used to convert each number in column B to a text value using the formula and number shown in column F. The TEXT function accepts a number as the value argument, the number format to use as the format_text argument. The number format can include codes for dates, times, numbers, currency, percentage, and so on, as well as custom number formats. Notice the output from the TEXT function is a text value, which is left-aligned by default in Excel.

Convert without formatting

To convert a number in A1 to a text value without number formatting, you can concatenate the number to an empty string ("") like this: With the number 100 in cell A1, the result is “100”.

Dave Bruns

Hi - I’m Dave Bruns, and I run Exceljet with my wife, Lisa. Our goal is to help you work faster in Excel. We create short videos, and clear examples of formulas, functions, pivot tables, conditional formatting, and charts.