Convert Percentage to Text in Excel: Methods and Tips

How-to basics · Updated November 22, 2026

To convert a numeric percentage to text in Excel, use the TEXT function: if A2 contains 25%, enter =TEXT(A2,"0%") in another cell; the result is the text “25%”. For one decimal place, use =TEXT(A2,"0.0%"). This keeps the percentage’s visible form but turns the result into text, not a number.

What “convert percentage to text” means

Excel normally stores percentages as numbers and applies percentage formatting to display them. For example, a cell displaying 25% usually contains the numeric value 0.25. Number formatting changes how a value looks; it does not change the value into text. This distinction matters when a report, exported file, or combined label needs the percent sign to be part of a text string.

The TEXT function creates text from a value using a number format you specify. Its result can be joined to words or other text, but it no longer behaves like a numeric percentage in calculations. If you need to calculate an average, compare percentages, or chart the data, keep the original numeric values and put the text results in a separate column.

Use TEXT to create a percentage string

Suppose A2 contains the numeric value 0.25 and is formatted to display as 25%. In B2, enter the following formula. The result is the text “25%”.

With the numeric percentage in A2, enter in B2:

=TEXT(A2,"0%")

The percent sign in the format code tells Excel to display the value as a percentage. Excel scales a decimal value by 100 for display, so 0.25 becomes 25%. The zero is a placeholder for a digit, and the percent sign is included in the returned text.

To show one decimal place, use this version. With 0.256 in A2, the result is the text “25.6%”.

With the numeric percentage in A2, enter in B2:

=TEXT(A2,"0.0%")

For two decimal places, use =TEXT(A2,"0.00%"); with 0.256 in A2, it returns “25.60%”. The number of zeroes after the decimal point specifies how many decimal places to show. TEXT rounds the displayed result to that precision, so use enough places when the distinction matters.

Choose the right format for the underlying value

Check whether the source value is a decimal percentage or a whole-number percentage before choosing a format. A cell containing 0.25 represents 25% when displayed as a percentage. A cell containing the number 25 represents 2,500% if you apply a percentage format, because Excel multiplies it by 100 for display.

If A2 contains the number 25 because your source stores percentages as whole numbers, divide by 100 in the TEXT formula. With that layout, the result is the text “25%”.

With a whole-number percentage in A2, enter in B2:

=TEXT(A2/100,"0%")

For example, if A2 is 25, A2/100 is 0.25 and the formatted text is 25%. Avoid adding a percent sign to a decimal without scaling it: joining the text “0.25” with “%” would produce “0.25%”, which represents a different percentage than 25%.

Combine a percentage with a label

TEXT is useful when a percentage needs to appear inside a sentence, label, or report heading. The formula below assumes a numeric percentage in A2 and adds the word “complete”. If A2 is 0.75, the result is the text “75% complete”.

With the numeric percentage in A2, enter in B2:

=TEXT(A2,"0%")&" complete"

The ampersand joins text pieces. You can also combine multiple values, provided each number is formatted as text in the formula. For example, the same approach can build a label containing a completion percentage and a status. Keep labels separate from calculation data, however: a cell containing “75% complete” is text and cannot be used directly as the numeric value 75% in arithmetic.

Convert formula results to fixed text values

A TEXT formula updates when its source value changes. That is useful for live reports, but sometimes you need a fixed text result—for example, before sending a workbook to a system that should not receive formulas. Copy the cells containing the TEXT formulas, then use Home > Paste > Values to replace the formulas with their current results. The pasted values remain text.

On Excel for Mac, the Home tab also provides the Paste and Values controls; in Excel for the web, use the paste options and choose Values where available. Menu labels or the layout can vary slightly by platform and update. Keep the source numeric column if you might need to revise the report or do further calculations. Pasting values removes the formulas’ connection to the source.

For a one-off entry, you can also type a leading apostrophe before a text percentage, such as '25%. Excel treats the entry as text and does not display the apostrophe in the cell. This is not the same as converting a numeric cell: it creates a text entry, and later changes to a source value will not update it.

Format a number as a percentage instead

If your goal is simply to show a percent sign while preserving calculations, do not convert the value to text. Select the numeric cells, then choose Home > Number Format > Percentage. Use the increase or decrease decimal controls in the Number group to adjust the displayed precision. You can also open Format Cells, choose Percentage, and set decimal places.

For a custom display, select the cells and open Format Cells, then choose Custom and enter a format such as 0% or 0.0%. On Windows, the Format Cells dialog can be opened from the Home tab’s Number group. Formatting affects display only: a value of 0.256 can display as 26% while remaining 0.256 for calculations. This is usually the best option for data tables and charts.

Convert text percentages back to numbers

Sometimes imported data looks like a percentage but is actually text—for example, a cell containing the characters “25%”. Changing its number format will not convert it. If A2 contains the text “25%”, use VALUE in another cell to convert it to the numeric decimal 0.25; then apply Percentage formatting if you want it to display as 25%.

With text such as “25%” in A2, enter in B2:

=VALUE(A2)

The result is a number, not text. Excel’s interpretation of decimal symbols and other number conventions can depend on regional settings. If imported strings include unusual spaces, currency symbols, or separators, clean or inspect the source before relying on a conversion formula. A quick check is to select the cell and inspect the formula bar and alignment, but alignment alone is not conclusive because formatting can change it.

Common mistakes and how to avoid them

  • Confusing display with stored value: A cell that displays 25% may still contain 0.25. Use TEXT only when the output really needs to be text.
  • Using the wrong scale: Applying a percentage format to 25 displays 2,500%. If 25 means 25 percent in your source, divide by 100 before formatting it as a percent.
  • Accidentally rounding: 0% shows whole percentages. For instance, 25.6% displays as 26%. Add decimal places in the format code if that rounding is not suitable.
  • Expecting text to calculate: A string such as “25%” is not the same as the numeric value 0.25. Keep a numeric source column for sums, averages, sorting by magnitude, and charts.
  • Trying to fix text by changing its format: Selecting Percentage in the Number Format menu does not turn an existing text string into a number. Convert the text value first, then apply the desired number format.

When to use text conversion

Use TEXT when the percentage is part of a sentence, a generated label, or an export that specifically requires text. Use ordinary percentage formatting when people need to calculate with the value. If you need both purposes, retain one numeric column and create a separate text column for presentation. This simple separation avoids many problems when someone later sorts, filters, edits, or reuses the workbook.

Remember that text percentages may sort differently from numbers: text sorting can put “100%” before “25%” because it compares characters rather than percentage magnitude. TEXT output also follows the number format you provide, so choose decimal places deliberately. For consistent results across a workbook, use the same format code for comparable values rather than manually typing percent signs into each result.

Frequently Asked Questions

Does formatting a cell as Text convert its percentage?
No. Changing a cell’s format to Text does not turn an existing numeric value into a text string. Use TEXT to generate text from the number, or convert an imported text percentage to a number if calculations are the goal.

How do I show 25% as text without decimal places?
If the underlying value is 0.25, use =TEXT(A2,"0%") in another cell. It returns the text “25%”. If the underlying value is the whole number 25, divide it by 100 in the formula before applying the percentage format.

Why does my result show 2,500%?
The source probably contains 25 rather than 0.25. Percentage formatting multiplies the displayed value by 100. Divide the whole-number source by 100 when converting it to a percentage string.

Can I use the converted text in calculations?
Not reliably as a numeric percentage. Keep the original numeric value for calculations, or convert a text percentage back into a number before using it in arithmetic.

Why does TEXT show fewer decimal places than my source?
The format code controls the displayed precision. For example, 0% rounds to a whole percent, while 0.0% displays one decimal place. Add zero placeholders after the decimal point to show more places.

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.