Need quick answer simple question

Beachson

Active Member
Joined
Oct 28, 2009
Messages
468
I have a column of phone number and instead of 1112223333 I would like to make every number look like this (111) 222-3333...how do I do this quickly
 

Some videos you may like

Excel Facts

Which came first: VisiCalc or Lotus 1-2-3?
Dan Bricklin and Bob Frankston debuted VisiCalc in 1979 as a Visible Calculator. Lotus 1-2-3 debuted in the early 1980's, from Mitch Kapor.

c_m_s_jr

Well-known Member
Joined
Mar 23, 2009
Messages
1,561
Change the formatting look under special and you should see one for phone #
 

Beachson

Active Member
Joined
Oct 28, 2009
Messages
468
what if I do not want to change the format how do I do it without changing the format
 

c_m_s_jr

Well-known Member
Joined
Mar 23, 2009
Messages
1,561
Well format is the fastest way, another way would be a formula, but the format will only change what is displayed, the actual cell value would not change.
 

Beachson

Active Member
Joined
Oct 28, 2009
Messages
468

ADVERTISEMENT

then If I wanted to past or merge that column on another spreadsheet or merge that column with another how would I just copy the text and not the format
 

Beachson

Active Member
Joined
Oct 28, 2009
Messages
468
I just want the look not the format really so the format serves no purnpose but to make it look a certain way
 

VoG

Legend
Joined
Jun 19, 2002
Messages
63,650

ADVERTISEMENT

Huh?

Type them in as you want them.
 

Beachson

Active Member
Joined
Oct 28, 2009
Messages
468
I know it sounds wierd someone just asked me for this and I formatted it but the format is not neccesary all the data is typed in already I just want to put the ( ) and - into them all
 

Beachson

Active Member
Joined
Oct 28, 2009
Messages
468
they said they couldnt merge the columns or copy paste and I assumed that you could special copy just visible cells to not carry the format over...right???
 

c_m_s_jr

Well-known Member
Joined
Mar 23, 2009
Messages
1,561
Not sure I understand what you mean. Here are two different approaches. The first is by formatting the cells to show (111) 222-3333 but the value would remain as 1112223333.

The second you would create a new column with the actual value being (111) 222-33333

Excel Workbook
ABC
11112223333(111) 222-3333(with formatting)
21112223333(111) 222-3333As formula
Sheet1
 

Watch MrExcel Video

Forum statistics

Threads
1,126,965
Messages
5,621,871
Members
415,862
Latest member
nascaline

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top