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.

You can use the built-in number formats in Excel as is, or you can create your own custom number formats to change the appearance of numbers, dates, and times.

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 …

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.

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

Round a number to the decimal places you want by using formatting and how to use the ROUND function in a formula to round to the nearest major unit such as thousands, hundreds, tens, or …

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 …

If a built-in number format does not meet your needs, you can create a new custom number format that is based on an existing number format and add it to the list of custom number formats.

To do this, you apply either the Currency or Accounting number format to the cells that you want to format. The number formatting options are available on the Home tab, in the Number group.