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 …

Changing default formats includes things like changing the font color, style, size, text alignment in a cell, or apply formatting effects. This article shows you how you can apply different formats …

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 …

On the Home tab, in the Number group, select the arrow next to the Number Format box, and then select Text. If you don't see the Text option, scroll to the end of the list.

When numbers are actually stored in cells as text, problems with calculations or sorting can occur. Read this article to learn how to fix this problem.

Lists the file formats that are supported in Excel. The topic also includes a list of unsupported file formats and some suggested workarounds.

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 …

Once you have converted the numbers formatted as text into regular numbers, you can change the way the numbers appear in the cells by applying or customizing a number format.

Occasionally, dates may become formatted and stored in cells as text. For example, you may have entered a date in a cell that was formatted as text, or the data might have been imported …

Excel automatically removes leading zeros, and converts large numbers to scientific notation, like 1.23E+15, in order to allow formulas and math operations to work on them. This article deals …