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 numbers in Excel. This topic lists the formats and provides brief descriptions.

If you specify two sections of format code, the first section of code is used for positive numbers and zeros, and the second section of code is used for negative numbers. When you skip code …

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.

If you are formatting a non-localized numeric string, you should use a user-defined numeric format to ensure that you get the look you want. Note: If the Calendar property setting is Gregorian …

Receive tips for best practices for formatting numbers as percentages and view examples of ways to calculate percentages in Excel.

Use a custom number format to display the number with text—without changing the sorting behavior of the number. In this way, you change how the number appears without changing …

The DOLLAR function, one of the TEXT functions, converts a number to text using currency format, with the decimals rounded to the number of places you specify. DOLLAR uses the …

How to use the SUBTOTAL function in Excel to return a subtotal in a list or database.

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 …