Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help converting a 10 digit number 2223334444 to 222-333-4444
In MS Excel (2007) I have a very long column with 10 digit numbers that need
to be changed to a telephone number with dashes. Can anyone help? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help converting a 10 digit number 2223334444 to 222-333-4444
Use a custom number format of 000-000-0000
-- Biff Microsoft Excel MVP "hmsteiner" wrote in message ... In MS Excel (2007) I have a very long column with 10 digit numbers that need to be changed to a telephone number with dashes. Can anyone help? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help converting a 10 digit number 2223334444 to 222-333-4444
"hmsteiner" wrote:
Subject: Help converting a 10 digit number 2223334444 to 222-333-4444 In MS Excel (2007) I have a very long column with 10 digit numbers that need to be changed to a telephone number with dashes. If you just want to change the appearance, try a Custom format like 000-000-0000. If you want to change the cell contents to text, try enter =TEXT(A1,"000-000-0000") into some cell, copy, and paste-special-value back to A1. PS: In the future, please copy details in the Subject line into the body of your message. Some NG readers do not display the entire subject line, in particular the MS Discussion Groups interface that you use. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Converting a 10 digit serial number to a date of mm/dd/yyyy | Excel Discussion (Misc queries) | |||
How to validate a cell to insert from 9 digit number to 13 digit number. | Excel Worksheet Functions | |||
How to validate a cell to insert from 9 digit number to 13 digit number. | Excel Worksheet Functions | |||
converting 8-digit number to date | Excel Discussion (Misc queries) | |||
When we enter a 16 digit number (credit card) the last digit chan. | Excel Discussion (Misc queries) |