Formatting Issues

Convert Excel Text Values to Number or Currency Format

Amos GikundaAmos Gikunda Nov 14, 2026 868 views

Question details

The user needs Excel values stored as text to display correctly in Number or Currency format.

Convert Excel Text Values to 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.
Before you start

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.

Solution 1Recommended

Convert numeric text with Text to Columns

Use this method for a column of ordinary numeric text, then apply the desired number format.

1
Select the text values

Select the cells in one column that contain the values to convert.

2
Convert the values

Go to Data > Text to Columns and click Finish to let Excel interpret the selected values.

3
Apply the format

With the cells still selected, open Home > Number and choose Number or Currency. Adjust the decimal places or currency symbol as needed.

4
Check the result

Enter =ISNUMBER(A1) in an empty cell, replacing A1 with a converted cell address. TRUE indicates that the value is numeric.

Convert numeric text with Text to Columns
Check values before converting: Test a small selection first. Excel may interpret some text as dates or remove leading zeros, so identifiers such as account numbers may need to remain as text.
Convert and format values

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. 1. Open the workbook: Open WPS Spreadsheets and use Open to select your Excel workbook.
  2. 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. 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. 4. Apply the format: Select the converted cells, open Format Cells, and choose Number or Currency with the desired decimal places.
Convert numeric text before applying currency formattingOpen and edit Microsoft Excel XLS and XLSX filesUse familiar spreadsheet formulas and formatting controlsWork with spreadsheets in a free, easy-to-use office suite
microsoft office alternative - wps office

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.