Convert Excel Text Values to Number or Currency Format
Question details
The user needs Excel values stored as text to display correctly in Number or Currency format.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Applying Number or Currency formatting to cells that currently appear to contain numeric values.
- Observed behavior
- The displayed values remain unchanged after formatting, potentially because Excel stores them as text.
Test a representative cell with =ISNUMBER(A1), replacing A1 with the cell address. If the result is TRUE, check the selected format and decimal places; if it is FALSE, convert the text to numbers first.
Convert numeric text with Text to Columns
Use this method for a column of ordinary numeric text, then apply the desired number format.
Select the cells in one column that contain the values to convert.
Go to Data > Text to Columns and click Finish to let Excel interpret the selected values.
With the cells still selected, open Home > Number and choose Number or Currency. Adjust the decimal places or currency symbol as needed.
Enter =ISNUMBER(A1) in an empty cell, replacing A1 with a converted cell address. TRUE indicates that the value is numeric.

Clean imported text with a formula
Use a formula when imported values contain nonbreaking spaces or other characters that prevent conversion.
Convert text to currency in WPS Spreadsheets
Use WPS Spreadsheets to convert ordinary numeric text with a formula, paste the results as values, and apply Number or Currency formatting.
- 1. Open the workbook: Open WPS Spreadsheets and use Open to select your Excel workbook.
- 2. Convert the text: In an empty cell, enter =VALUE(A1), replacing A1 with the first text value's cell address. Drag the fill handle down to convert the remaining values.
- 3. Paste converted values: Check the results, copy them, and use Paste Special > Values to paste them into the original range or a new range.
- 4. Apply the format: Select the converted cells, open Format Cells, and choose Number or Currency with the desired decimal places.

Frequently Asked Questions
Why does Currency format not change my Excel cells?
The values may be stored as text. Enter =ISNUMBER(A1) in an empty cell, replacing A1 with the cell to check. If it returns FALSE, convert the text to numbers before applying Currency format.
What if ISNUMBER returns TRUE but the display is still wrong?
Select the cell and check its format under Home > Number. Choose Number or Currency and adjust the decimal places and currency symbol. If you use a custom format, inspect its format code.
How do I convert a single text value to a number?
Select the cell, re-enter its value, and press Enter. Then use =ISNUMBER(A1) to check the cell and apply Number or Currency from Home > Number.
Can leading zeros disappear during conversion?
Yes. Numeric conversion removes leading zeros from the underlying value. Keep identifiers as text, or use an appropriate custom number format if the zeros are only needed for display.




