write phone number in excel tutorials

How to Change the Phone Number Format Into a Series of Numbers in Excel

write phone number in excel tutorials

 

 

write phone number in excel When you type a seven-or-ten-digit phone number into an Excel cell that uses the phone number format, Excel will automatically change the way the number looks so that it appears as a phone number. If you want to change the number’s appearance, there are two ways to do it, depending on how you want the final result to look.

write phone number in excel

 

Series in Single Cell to write phone number in excel

Step 1Open the Excel 2010 file that contains the phone numbers you want to change. Click on the cell that contains the phone number, or click on the range of cells if you want to change the format for several cells on your spreadsheet.

Step 2Select the “Home” tab at the top of the Excel window.

Step 3Click the drop-down arrow in the “Number” area of the ribbon. Choose “General” from the list of options and your phone numbers will now appear as just a series of numbers.

Series in Columns to write phone number in excel

Step 1Open the Excel 2010 files that holds your phone numbers. Click on the cell that you want to change into a series of numbers spread out over several columns, or click on the letter above the column that contains multiple phone numbers. Because of how this process will overwrite items on the spreadsheet, you can’t perform this task on multiple columns at once.

Step 2Select the “Data” tab at the top of the Excel window, then click the “Text to Columns” button. The text to columns wizard will appear on the screen.

Step 3Click the radio button next to “Fixed Width,” then click “Next.” Then click the mouse button just after the first number that appears in the white box in the wizard. You will see a line appear, which signifies where a column break will go. Click after the second number to add another break, then continue to add breaks after each number. Click “Next” to continue.

Step 4Select “General” from the list that appears so that you numbers will display as numbers on the spreadsheet. Click the small box next to “Destination,” then click the cell on the spreadsheet where you want your phone number to start. The numbers will overwrite the information in the columns to the right of the cell where you choose to start, so be sure you are choosing some place that doesn’t have any important data to the right of it.

Step 5Click “Finish” to close the wizard and your phone number will appear as a series of numbers spread out over several columns.

Leave a comment

Your email address will not be published. Required fields are marked *