How to Change Excel Phone Numbers from Parentheses to Hyphen Format with WPS Office
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.
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.
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.
Highlight the cells or column that displays phone numbers as (###) ###-####.
Press Ctrl+1, then choose the Custom category.
In the Type box, enter ###-###-#### and click OK.

Reformat Text Phone Numbers with Flash Fill
Use this when phone numbers are stored as text strings containing parentheses, spaces, and hyphens.
Clean Text Phone Numbers with Find and Replace, Then Apply a Number Format
Use this when text values include multiple extra characters or when Flash Fill does not detect the pattern.
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. Open the Excel workbook in WPS Spreadsheets: Launch WPS Office, click Menu > Open, and select the workbook that contains the phone number column.
- 2. Select the phone number cells: Highlight the cells or column that displays phone numbers as (###) ###-####.
- 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. 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.

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.




