Formatting Issues

How to Change Excel Phone Numbers from Parentheses to Hyphen Format with WPS Office

Huda QurayshiHuda Qurayshi Nov 13, 2026 868 views

Question details

The user needs to reformat phone numbers in an Excel-compatible spreadsheet from (###) ###-#### to ###-###-####, and the correct method depends on whether the values are numeric cells or text strings.

Product
WPS Spreadsheets
Device & OS
not provided
Scenario
Editing a worksheet containing US-style phone numbers currently displayed with parentheses and a hyphen.
Observed behavior
Phone numbers should display consistently as ###-###-#### without parentheses or extra spaces.
Before you start

First identify whether the phone number cells contain real numbers or text strings: select the column and check the Home > Number Format box. This determines whether a custom format alone is enough or whether the text must be cleaned first.

Solution 1Recommended

Apply a Custom Number Format for Numeric Phone Numbers

Use this when the cells contain actual numbers and the parentheses appear only through cell formatting.

Custom number formats only change the display, not the underlying value. This is the fastest method when WPS Spreadsheets or Excel stores phone numbers as numbers with existing phone formatting.

1
Select the phone number cells

Highlight the cells or column that displays phone numbers as (###) ###-####.

2
Open the Format Cells dialog

Press Ctrl+1, then choose the Custom category.

3
Enter the hyphen format

In the Type box, enter ###-###-#### and click OK.

Apply a Custom Number Format for Numeric Phone Numbers
Result: The selected numeric phone numbers immediately display as ###-###-#### without parentheses.
Format Excel files in WPS Office

Reformat Phone Numbers in WPS Spreadsheets

Use WPS Spreadsheets to open your Excel workbook and convert phone numbers from (###) ###-#### to ###-###-#### with custom number formats, Flash Fill, or Find and Replace—no separate Excel license required.

  1. 1. Open the Excel workbook in WPS Spreadsheets: Launch WPS Office, click Menu > Open, and select the workbook that contains the phone number column.
  2. 2. Select the phone number cells: Highlight the cells or column that displays phone numbers as (###) ###-####.
  3. 3. Apply a custom number format: Press Ctrl+1, click Custom, enter ###-###-#### in the Type box, and click OK if the values are numeric.
  4. 4. Clean text values if needed: If values remain unchanged, use Ctrl+E Flash Fill after typing one example, or use Ctrl+H to remove parentheses, spaces, and hyphens, then apply the custom format.
Handles .xlsx, .xls, and other Excel formats without data lossApplies Excel-compatible custom number formats for phone numbersCleans text phone numbers with Flash Fill and Find and ReplaceFree and lightweight Office interface for easy migration
microsoft office alternative - wps office

Frequently Asked Questions

Why does the ###-###-#### custom format not change my phone numbers?

The cells are likely text strings rather than numeric values. Select the cells and check the Home > Number Format box. If they are text, use Flash Fill or Find and Replace to clean the punctuation first.

Can I use Flash Fill in WPS Spreadsheets to reformat phone numbers?

Yes. Enter the first desired phone number in the adjacent cell, then press Ctrl+E or click Data > Flash Fill. WPS Spreadsheets applies the pattern to the remaining cells.

Does applying a custom number format remove parentheses from the original cell value?

No. For numeric cells, the custom format only changes how the value is displayed. The underlying value remains unchanged, so the original phone number is still editable.

Will the reformatted phone numbers stay compatible with Microsoft Excel?

Yes. WPS Spreadsheets saves custom number formats in .xlsx files, so Microsoft Excel displays the phone numbers with the same ###-###-#### format.