Excel Text Function for Percentage: How to Format

Formulas & functions · Updated November 22, 2026

The main Excel text function for displaying a percentage is TEXT, used like =TEXT(A1,"0.0%") to convert a decimal number into a percentage string. For example, if cell A1 contains 0.125, the formula returns “12.5%”. However, for most purposes you should use Excel’s built-in percentage number format instead, because it keeps the value numeric and usable in further calculations.

Why Use a Text Function for Percentages?

Excel stores percentages as decimal fractions: 50% is stored as 0.5, and 100% as 1. When you apply the Percentage number format, Excel multiplies the cell value by 100 and displays a percent sign, but the underlying value stays decimal. The TEXT function is useful when you need to embed a percentage inside a text string, such as in a report title, a concatenated label, or a formula that builds a sentence like “Completion: 75%”. Using TEXT gives you full control over the number of decimal places and the presence of a percent sign, without altering the original cell.

How the TEXT Function Works

The TEXT function has two arguments: the value to format and a format code. The format code uses the same symbols as Excel’s custom number formats. For percentages, you include the percent sign (%) in the format code. Excel multiplies the value by 100 and adds the percent sign. For example, =TEXT(0.25,"0%") returns “25%”. You can control decimal places: =TEXT(0.125,"0.0%") returns “12.5%”. To show a plus sign for positive percentages, use +0%;-0%. To include a thousands separator, use #,##0%.

Step-by-Step: Using TEXT to Format a Percentage

  1. Assume your decimal value is in cell A1 (e.g., 0.25).
  2. In cell B1, enter the formula: =TEXT(A1,"0%").
  3. Press Enter. The result displays as “25%” (as text).
  4. To show one decimal place, use =TEXT(A1,"0.0%").
  5. To combine with other text, use concatenation: ="Progress: "&TEXT(A1,"0%").

On Mac, the same formula works identically. In Excel for the web, TEXT is supported as well.

Choosing Between TEXT and Number Format

Use the built-in Percentage format (Home > Number > Percent Style) when you want the cell to remain numeric. That way, you can still perform arithmetic on it, such as multiplying by a total. Use TEXT when you need a text output, for example in a chart title, a mail merge, or a concatenated string. Remember that TEXT returns a string, so you cannot use the result in further numeric calculations without converting it back (which is rarely needed).

Common Problems and Misconceptions

A frequent issue is that =TEXT(A1,"%") (without a number format) returns an error or unexpected result. You must include a numeric placeholder like 0 or # before the percent sign. Another misconception: applying the Percentage format to a cell that already contains a number like 25 will display 2500%, because Excel assumes you entered a decimal. To avoid this, enter the decimal (0.25) or divide by 100 in the formula. Also note that TEXT converts the value to text, so sorting and filtering may behave differently.

Alternatives to TEXT for Percentages

If you only need to display a percentage without changing the value, use the Percentage number format. For dynamic text in Excel 365, you can use the LET function to store a formatted string, but TEXT is the simplest. For more complex formatting, such as conditional colors, you would use Conditional Formatting, not TEXT. If you need to extract the numeric part from a text percentage (e.g., “25%”), use VALUE or NUMBERVALUE after removing the percent sign with SUBSTITUTE.

Frequently Asked Questions

How do I show a percentage with two decimal places in Excel text?
Use the format code 0.00% in the TEXT function, like =TEXT(0.125,"0.00%") which returns “12.50%”.

Why does my percentage show as 2500% instead of 25%?
That happens when the cell contains 25 (not 0.25) and you apply the Percentage format. Excel multiplies by 100. To fix, either enter 0.25 or divide by 100 in the formula: =TEXT(A1/100,"0%").

Can I use TEXT to format a percentage in a chart title?
Yes, you can create a cell with the TEXT formula and then reference that cell in the chart title, or use a dynamic chart title with a formula that includes TEXT.

Does the TEXT function work in Google Sheets?
Yes, Google Sheets has a similar TEXT function, but the format codes are slightly different (e.g., you may need to use “0.00%”). Always test in your specific application.

Is there a way to format a percentage without changing the underlying value?
Yes, use the Percentage number format (Ctrl+Shift+% on Windows, Cmd+Shift+% on Mac). This only changes the display, not the value.

Can I use TEXT with a negative percentage?
Yes, the format code can include a negative section, like 0%;-0% to show a minus sign. For example, =TEXT(-0.05,"0%;-0%") returns “-5%”.

Related

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Formulas & functions

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.