Excel TEXT Percentage: How to Format Values as Percentages

How-to basics · Updated November 18, 2026

If A1 contains a decimal percentage such as 0.25, use =TEXT(A1,"0%") to display it as 25%. The TEXT function returns that formatted result as text, not as a numeric percentage, so it is useful for labels and messages but usually not the best way to format values you still need to calculate with.

How the TEXT function displays a percentage

Excel stores percentages as numbers: 25% is stored as 0.25, and 100% is stored as 1. The percent sign in a number format tells Excel to multiply the displayed value by 100 and show the symbol. The TEXT function applies a number format to a value and returns the formatted display as a text string.

For example, if A1 contains 0.25, the formula in the opening paragraph returns the characters “25%”. The underlying value in A1 remains 0.25; the formula does not alter that cell. However, the result in the cell containing the formula is text, so it behaves differently from a numeric percentage.

This distinction matters because the goal may simply be to make a number look like a percentage, or it may be to insert a percentage into a sentence. For the first goal, ordinary cell formatting is generally preferable. For the second, TEXT is a practical way to control how the number appears inside a larger text result.

Choose a percentage format code

The second part of the TEXT formula is a format code enclosed in straight double quotation marks. The number of zeroes after the decimal point controls how many decimal places are displayed. Choose a format based on the detail readers need, rather than showing precision that the source data does not support.

  • "0%" shows a whole percentage, such as 26%.
  • "0.0%" shows one decimal place, such as 25.7%.
  • "0.00%" shows two decimal places, such as 25.67%.
  • "#,##0.0%" adds a thousands separator when a percentage is large, such as 1,250.0%.

With A2 containing the numeric value 0.2567, =TEXT(A2,"0.0%") returns “25.7%”. The displayed result is rounded to one decimal place. With the same cell and =TEXT(A2,"0.00%"), Excel returns “25.67%”. Those are different display choices for the same underlying number, not different calculations.

To make a percentage part of a label, place the text around the formatted value with the ampersand concatenation operator. If A2 contains 0.2567, =TEXT(A2,"0.0%")&" complete" returns “25.7% complete”. The complete result is text, including the percentage and the word after it.

Use the correct underlying value

A common source of surprising results is entering a whole number where Excel expects a decimal fraction. If a cell contains 0.25, a percentage format displays 25%. If it contains 25, a percentage format displays 2500%, because Excel treats 25 as twenty-five whole units and scales the display by 100. The percent sign in a format code does not mean “attach a symbol without changing the scale.”

Check how the value was entered or calculated before applying TEXT. A ratio such as 25 divided by 100 is 0.25 and represents 25%. A value already expressed on a 0-to-100 scale may need to be divided by 100 before using a percentage format. Do not divide automatically, though: imported data, survey exports, and other spreadsheets may already store percentages as decimals.

For example, if B2 contains 25 as a numeric value that represents 25 percentage points, and you want the output to show 25%, the formula must first convert that scale. With B2 holding 25, =TEXT(B2/100,"0%") returns “25%”. If B2 instead contains 0.25, dividing again would produce 0.25%, which is incorrect for that data. Confirm the source convention before choosing the formula.

Rounding and displayed precision

TEXT rounds the displayed number to match the format code. It does not change the original source cell. A value such as 0.2567 shown with a whole-percent format appears as 26%; shown with one decimal place, it appears as 25.7%. This is normal rounding, not a loss of precision in the source value.

That difference can become important in reports. A displayed 26% may look as though it equals exactly 26%, even when the stored value is 25.67%. If a reader needs to reproduce calculations or compare small differences, show an appropriate number of decimal places or provide access to the underlying data. Avoid using a rounded text result as an input to later arithmetic.

Formatting also does not correct a calculation. If a percentage represents a part divided by a total, confirm that the ratio itself is correct before displaying it. For instance, a percentage-point change and a percentage change are not interchangeable: a movement from 20% to 25% is an increase of 5 percentage points, but a 25% increase relative to the starting value. TEXT can format either numeric result, but it cannot decide which measure your question calls for.

When TEXT is useful—and when it is not

TEXT is especially useful when the formatted number must sit inside a sentence, heading, or generated label. It can keep a percentage readable in a message such as a completion status or a report caption. It is also useful when a formula builds a single text string from several values and the default number display would be awkward.

For a column of percentages that people may sort, filter, average, chart, or use in other formulas, keep the cells numeric and apply percentage formatting instead. If a TEXT formula produces “25%”, Excel sees text characters, not the numeric value 0.25. Text may sort differently from numbers, may not be included in numeric calculations, and can cause chart or downstream formula behavior that differs from the result you intended.

When combining a numeric value with text, decide whether the resulting sentence needs to be treated as text. A report label is naturally text, so TEXT is appropriate there. A table of percentage results is usually better as numbers with a display format. You can also keep a numeric result in one cell and create a separate descriptive label in another, preserving both calculation-friendly data and a readable explanation.

Format the cell instead of using a formula

If the goal is only to show a numeric cell as a percentage, format the cell directly. In Excel for Microsoft 365 on Windows, select the cells and choose Home > Number > Percent Style. To control decimal places, use Home > Number > Increase Decimal or Decrease Decimal. You can also open Format Cells with Ctrl+1, select the Percentage category, choose decimal places, and select OK.

In Excel for Microsoft 365 on Mac, the Home tab also provides the Number Format and percentage controls; the Format Cells dialog can be opened from the format options or the Format menu. The exact keyboard shortcut for a dialog can differ on Mac, so the ribbon or menu is a reliable route. Excel for the web also offers number-format controls on its Home tab, though the layout can differ slightly from the desktop ribbon.

Cell formatting changes how the number appears without converting the value to text. The formula bar continues to show the underlying number, and other formulas can still use it as a number. You can select a different number of decimal places later without rewriting formulas. If a value is already produced by a formula, formatting its result cell is still usually the cleanest way to display a percentage.

Common problems and fixes

  • The result is 2500% instead of 25%. The input is probably 25 rather than 0.25. Verify the source scale, then convert the number only if the data is genuinely stored from 0 to 100.
  • The result cannot be used as a number. TEXT returns text by design. Apply percentage formatting to the numeric cell instead if you need calculations, sorting, or charting.
  • The output has too many or too few decimals. Adjust the format code, such as changing "0%" to "0.0%". This changes the displayed precision, not the source value.
  • The formula appears literally in the cell. Check that the cell is not formatted as Text and that the entry begins as a formula. If necessary, change the cell to General, then re-enter the formula.
  • The formula reports an error. Check that the referenced cell contains a usable value and that the format code has opening and closing straight quotation marks. Curly quotation marks copied from formatted text can break a formula.

Excel installations configured for different regional settings may use a different list separator in formulas. The examples here use commas, the standard syntax requested for these formulas; if Excel rejects an otherwise correct formula, check the list-separator setting used by that installation. Do not replace the quotation marks around the format code with single quotes.

Frequently Asked Questions

Does TEXT change a number into a percentage?

It returns a text representation formatted as a percentage; it does not change the original number. A source value of 0.25 can be displayed as “25%”, while the TEXT result itself is text rather than a numeric 25% value.

Why does Excel show 0.25 as 25%?

Percentage formatting multiplies a decimal value by 100 for display and adds a percent sign. This is why 0.25 represents 25%, while a stored value of 25 displays as 2500% when formatted as a percentage.

Can I show one decimal place with TEXT?

Yes. Use the format code "0.0%" for one decimal place or "0.00%" for two. Excel rounds the displayed result to the chosen precision.

Should I use TEXT or percentage cell formatting?

Use TEXT when the formatted percentage must become part of a text label or sentence. Use cell formatting when you want the value to remain numeric for calculations, sorting, filtering, or charting.

Can I calculate with a TEXT percentage result?

It is possible to convert text back to a number in some situations, but that adds unnecessary complexity and can be error-prone. Keep percentage calculations numeric and apply a display format unless a text string is specifically required.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

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

Spotted an error in this guide? Let us know.