Formatting Issues

How to Format Phone Numbers with Dashes in Excel 365

Olivia Miller Sep 30, 2026 869 views

Question details

The user needs to display a standard 10-digit number as a formatted phone number with dashes (e.g., 916-521-0404) without changing the actual numerical value of the cell.

How to Format a Phone Number with Dashes in Excel 365

Product: Excel 365
Device & OS: not provided
Scenario: Formatting raw 10-digit numerical data to improve readability by displaying it as a standard US phone number.
Observed behavior: Converting a continuous string of 10 digits into a dashed ###-###-#### format while ensuring the cell's underlying value remains a pure number.

Before you start

Ensure your phone numbers are entered as pure 10-digit numeric values without any spaces or existing text characters before applying a new format.

Solution 1Recommended

Apply a Custom Number Format

This is the recommended method because it visually changes the display of the number into a phone format while keeping the underlying data strictly numeric, making it ideal for sorting and filtering.

Using a custom number format is highly efficient for data sets. It ensures that any formulas referring to these cells will still recognize the data as numerical.

Select the target cells

Highlight the cell or range of cells containing the 10-digit numbers you want to format.

Open the Format Cells dialog

Right-click the highlighted cells and select 'Format Cells' from the context menu, or press the 'Ctrl + 1' keyboard shortcut.

Enter the custom format

In the Format Cells window, go to the 'Number' tab and choose 'Custom' from the category list. In the 'Type' field on the right, enter ###-###-####.

Apply the formatting

Click 'OK' to apply. Your 10-digit numbers will now automatically display with dashes.

Keep Underlying Data Intact: If you click on the formatted cell and look at the formula bar, you will see the original 10-digit number remains unchanged.

Solution 2

Use the TEXT Function

Use this method if you need to extract and convert the number into an actual text string with dashes in a separate column.

Seamless Data Formatting

Format Phone Numbers Effortlessly in WPS Spreadsheet

WPS Office offers a powerful, fully compatible Spreadsheet application that allows you to use custom number formats and advanced formulas just like Excel. Handle large datasets and format them beautifully without spending a dime.

1. Open your file in WPS Spreadsheet: Launch WPS Office and open your workbook containing the phone numbers.
2. Access cell formatting: Select the cells you want to modify, right-click, and choose 'Format Cells'.
3. Apply the phone format: Navigate to the 'Custom' category, type ###-###-#### in the input box, and click OK.
4. Save your document: Click the Save icon to preserve your cleanly formatted data in .xlsx format.

100% format compatibility with Microsoft Excel (.xlsx) files.Fully supports custom number formatting including complex phone number setups.Built-in TEXT function and other advanced formulas for seamless data manipulation.Free, lightweight, and features an intuitive tabbed interface for increased productivity.

microsoft office alternative - wps office

Frequently Asked Questions

Why did the leading zero disappear when I typed a phone number?

By default, spreadsheet software drops leading zeros in numeric cells because numbers do not begin with zero mathematically. To keep a leading zero, format the cell as Text before typing, or use a custom format like 000-000-0000 instead of hashtags.

Can I format phone numbers with parentheses instead of just dashes?

Yes. In the Format Cells > Custom menu, you can enter the pattern (###) ###-#### in the Type box to display your 10-digit numbers with traditional parentheses and a dash.

Does changing the custom number format change the actual data?

No. Applying a custom number format only changes how the data looks visually on the screen or when printed. The underlying value stored in the cell remains the exact original sequence of digits.

What if my phone numbers include a country code?

You can modify your custom format code to accommodate extra digits. For example, for an 11-digit number starting with a country code, you can use a custom format like +#-###-###-####.

Excel & Data Problems