Yes. If A2 contains the text 25%, enter =VALUE(A2) in another cell to convert it to a real numeric percentage: the result is 0.25, which displays as 25% when the cell is formatted as a percentage. Select the result cells and choose Home > Number > Percent Style if you want that display.
What Excel means by percentage text
A cell can show 25% without containing text. If Excel recognizes the entry as a percentage, its underlying numeric value is 0.25, and the percent sign is a display format. A percentage stored as text is different: Excel treats the characters as text, so calculations, sorting, averages, and charts may not handle it as a number.
Text percentages often arrive from a CSV file, a web page, or another system. A leading apostrophe, extra spaces, or import settings can also leave values as text. The appearance alone may not reveal which kind of value you have. A quick test is to select the cell and try a calculation or check whether it is recognized as a number; left alignment is a clue in some default layouts, but alignment can be changed and is not a dependable test.
When Excel converts the text 25%, the appropriate numeric percentage is 0.25—not 25. Percentages are stored as fractions of 1: for example, 100% is 1 and 7.5% is 0.075. The number format adds the percent sign and scales the displayed value accordingly.
Convert a text percentage with VALUE
For text percentages that use the decimal and thousands separators expected by your Excel regional settings, VALUE is the most readable formula. With the text 25% in A2, enter =VALUE(A2) in B2. It returns the number 0.25. Format B2 as a percentage to display 25%.
To process a list, put the formula beside the first text value, then fill it down the column. You can drag the fill handle at the lower-right corner of B2 or copy the formula and paste it into the remaining rows. Relative references adjust automatically, so the next row uses A3, then A4, and so on. Once you have checked the results, you can copy the converted cells and use Paste Special > Values if you need to replace the original text. Keep a copy of the source column until you have verified the conversion.
VALUE asks Excel to interpret text as a number using the conventions available in the workbook’s regional context. That is usually convenient for ordinary values such as 25%, but it matters when a file was created with different decimal or thousands separators. If VALUE returns an error or an unexpected result, check the source characters and locale before changing the formula.
Use double unary or arithmetic coercion
A shorter alternative is to coerce the text into a number with two minus signs. With text 25% in A2, enter =--A2 in B2. Excel interprets the percentage text as 0.25; applying two negatives leaves the value positive. Format the result as a percentage if you want to see 25% rather than 0.25.
This method is handy in compact formulas, but VALUE is often clearer when someone else will need to understand or maintain the worksheet. Both approaches rely on Excel being able to parse the text. Neither repairs every malformed entry, such as a value with an unexpected word or separator. If you use a formula in a large dataset, compare several converted values against the originals before filling it down or using the results in calculations.
Clean spaces and imported characters
Some imported percentages contain ordinary spaces or nonbreaking spaces, a character commonly used to prevent a line break on web pages. Excel’s TRIM function removes repeated ordinary spaces at the beginning or end, but it does not by itself remove nonbreaking spaces. SUBSTITUTE can replace that character with a normal space first.
With text such as 25% in A2 that may contain nonbreaking spaces, enter =VALUE(TRIM(SUBSTITUTE(A2,CHAR(160)," "))) in B2. For a clean value of 25%, the result is 0.25. TRIM then removes extra ordinary spaces, and VALUE converts the cleaned percentage text. This formula keeps the percent sign, allowing VALUE to interpret the text as a percentage.
If the source contains other unwanted characters, identify them before stripping characters indiscriminately. For instance, removing punctuation might turn a value with a decimal comma into a different number under settings that expect a decimal point. It is safer to inspect a few raw cells, including the formula bar, and decide which characters are noise and which carry meaning.
Check whether the conversion worked
After converting, check more than the visible formatting. A true numeric value can be used in arithmetic, while text generally cannot participate in ordinary numeric calculations without another conversion. With the result in B2, enter =ISNUMBER(B2) in C2; for a successful conversion, C2 returns TRUE.
Another practical check is to use a small calculation on a separate test row. If B2 is 0.25 and C2 contains the numeric value 100, entering =B2*C2 in D2 returns 25. The result confirms that Excel is using 25% as one quarter. If the cells still contain text, a formula may return an error or behave differently depending on how Excel coerces the values.
Do not use the displayed number alone as proof. A cell formatted as General may show 0.25, while a percentage format shows 25%; these are two displays of the same underlying numeric value. To apply a percentage format in Microsoft 365 for Windows, select the converted cells and use Home > Number > Percent Style. In Excel for Mac or Excel for the web, the formula works the same way; use the Home tab’s number-format controls to choose Percentage. Add decimal places if the values need more precision in their display.
Choose the right conversion method
For most worksheets, choose VALUE when you want a clear, easy-to-review formula. Use double unary if a compact coercion is useful in a larger formula and the input is already clean. Use a cleanup formula only when the source actually contains spaces or other known irregularities. The simplest method that matches the data is usually the easiest to audit later.
- One or a few cells: Use
=VALUE(A2), inspect the result, and format it as a percentage. - A column of consistent text: Fill the VALUE formula down, then verify a sample near the top, middle, and bottom.
- Text with web-imported spaces: Clean the known nonbreaking spaces before converting.
- Repeated imports: Consider fixing the import or transformation process so the same text problem does not recur each time.
Excel’s Text to Columns tool can sometimes convert numeric-looking text during a reparse. On Windows, select a copy of the affected column, choose Data > Text to Columns, select Delimited, choose Next twice, keep General as the column data format, and select Finish. Results depend on the source text and regional settings, so use a duplicate column or a copy of the workbook first and inspect the output. The formula approach is easier to control when you need a repeatable, row-by-row conversion.
Common mistakes and locale issues
A frequent mistake is removing the percent sign and treating the remaining digits as the final percentage. With text 25%, removing % leaves 25, which is one hundred times the correct fractional value for 25%. If you deliberately remove the sign, you must also divide by 100 to get 0.25. For normal spreadsheet calculations, converting the original text as a percentage is less error-prone.
Regional settings can affect text such as 12,5% or 12.5%. One locale may use a comma for the decimal separator while another uses a period. If a file was exported under different conventions, VALUE may fail or interpret the characters in an unexpected way. Check the source system’s export settings and Excel’s regional conventions; do not replace commas and periods globally unless you have confirmed what each separator means in the data.
Also distinguish conversion from formatting. Applying Percentage format to text does not reliably turn that text into a number. Conversely, converting text to 0.25 without applying a percentage format is still a successful conversion; it simply displays as 0.25. If a formula result looks wrong, check both its underlying value and its number format.
What to do with blanks and invalid rows
Mixed columns may include blank cells, labels, dashes, or error-like text alongside percentages. A direct VALUE formula is appropriate for clean percentage rows, but an invalid entry can produce an error rather than a usable number. Do not silently treat every unusual entry as zero: a dash may mean missing data, not 0%.
Before converting a mixed column, decide what blanks and placeholders mean for the analysis. You can filter the source column to review unusual entries, correct them according to the data provider’s definitions, or convert only rows known to contain percentages. Keep an untouched source column when the meaning of a placeholder is uncertain. That preserves the original information and makes it easier to revisit decisions later.
Frequently Asked Questions
Does Excel store 25% as 25 or 0.25?
As a numeric percentage, Excel stores 25% as 0.25. Percentage formatting displays that fraction multiplied by 100 with a percent sign. Text containing the characters 25% is not a numeric percentage until Excel converts it.
Why does VALUE return an error for a percentage?
The text may contain an unexpected space, nonbreaking space, symbol, or decimal separator that Excel cannot interpret under the current regional settings. Inspect the cell contents, clean only known unwanted characters, and check whether the source uses the same decimal convention as Excel.
Can I convert percentage text without a helper column?
You can try converting a copy with Data > Text to Columns and the General data format, but results can vary with the text and locale. A helper formula is often safer because it leaves the source intact and makes each conversion visible for checking.
Why does my converted value show 0.25 instead of 25%?
The conversion can be correct even when the cell displays 0.25. Apply Percentage format using Home > Number > Percent Style to display 25%. The underlying value remains 0.25, which is the correct numeric representation.
Should I remove the percent sign before converting?
Usually, no. VALUE can interpret a text value such as 25% directly and return 0.25. Removing the sign without dividing the remaining number by 100 would produce 25, not the correct numeric percentage.
Related
- Change Text to Numbers in Excel: Easy, Reliable Methods
- Center Across Selection in Excel: Add It to Quick Access
- Change Block Capitals to Lowercase in Excel
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- How to Set Out of Office in Outlook on a Windows PCTo set an out-of-office reply in Outlook on a Windows PC, open Automatic Replies, switch them on, write…
- Excel Shortcut to Go to the Bottom of a Data ColumnIn Excel for Microsoft 365 on Windows, press Ctrl+Down Arrow to jump to the bottom edge of the…
- Excel Keyboard Shortcut for Next Sheet: Ctrl+Page DownIn Excel for Microsoft 365 on Windows, press Ctrl+Page Down to move to the next visible sheet in…
- Excel Conditional Formatting for Dates Coming DueTo highlight Excel dates coming due, select the date cells, choose Home > Conditional Formatting > New Rule…
- How to Split a Cell in Excel: Easy Ways to Separate TextThe easiest way to split text in an Excel cell is to select it, then choose Data >…
- How to Add a Watermark in a Word Document on Any PageIn Word for Microsoft 365 on Windows, open the document and choose Design > Watermark to add a…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.