How do you change the format of the source data of a phone number in excel?

Question

I have a database that contains user-entered phone numbers. All the phone numbers appear in this format: xxxxxxxxxx. I know how to use Excel formatting to make the phone numbers appear like this: (xxx) xxx-xxxx. What I want to do is make the data within each cell have that same formatting.

Example: Row 2 has a phone number that appears in the cell as [phone]. When I click on that cell, the data that appears in the fx box is 1234567890 -- it is not formatted. I want it to appear the same as how the formatted version appears. The reason I want to do this is so I can import the data into another program and have it appear formatted in the other program.

Thanks!

Answer 1

Export the file to a text based format. (i.e. tab delimited or csv)

Open the exported file with excel.

The source data should be text now and the format you like.

Answer 2

Highlight the whole column (click the column header) then click format then cells. Select Special then Phone Number and then save. Any number entered into the cells in that column will now appear as a phone number.

Answer 3

format Cells custom, and merely variety 0000000000 and click ok attempt What Wesley advise, and with the intention to no longer to have records in 2 diverse places, reproduction the variety the place the Mid function is and then do a paste particular values the place the records initially is, then delete the variety the place the Mid function is.

Answer 4

look into Help menu on RIGHT, LEFT, MIDDLE and use the CONCATENATE command and then copy and do a Paste Special and pick the Value into another new column