The TEXT function lets you change the way a number appears by applying formatting to it with format codes. It's useful in situations where you want to display numbers in a more readable format, or you …

Important: The calculated results of formulas and some Excel worksheet functions may differ slightly between a Windows PC using x86 or x86-64 architecture and a Windows RT PC using ARM …

Use the Format function in an expression You can use Format wherever you can use expressions. For example, you can use it in a query as part of a field alias, or in the Control Source property of a text …

If you specify only one section of format code, the code in that section is used for all numbers. If you specify two sections of format code, the first section of code is used for positive numbers and zeros, …

You can also use the TEXT function to convert a number to text in a specific number format. For examples of this technique, see Keep leading zeros in number codes.

Lists all Excel functions by their category, such as Logical functions or Text functions.

In the Type field, edit the number format codes to create the format that you want. To display both text and numbers in a cell, enclose the text characters in double quotation marks (" "), or precede the …

The following list describes the text values that the CELL function returns when the Info_type argument is "format" and the reference argument is a cell that is formatted with a built-in number format.

Feb 2, 2012 · If you don’t like the default date format, you can pick a different one in Excel, like February 2, 2012 or 2/2/12. You can also create your own custom format in Excel.

Select the Number tab, then in the Category list, select Custom and then, in the Type box, type the number format, such as 000-00-0000 for a social security number code, or 00000 for a five-digit …