Phone Format PHYSICAL

G

Guest

I have a phone number coming in. I know I can change the format but I also
need to PHYSICALLY change the cell as well. The cell HAS to appear as...

(123)456-7890

It HAS to because I have to try and De-Dupe it through Access and run an
Unmatched query against it so that it attempts to match up correctly to the
physical table wich is formatted as (123)456-7890.

Can someone help me out here???

Thanks!
 
K

Ken Wright

How does the data come in, is it just 1234567890? If so then assuming your
data is in Col A and starting in A1, in b1 try

=TEXT(A1,"(000)000-0000")

Copy down, then copy all and paste special as values.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Format Phone Number Field VBA 2
Transforming messy database into clean database 4
Formula to change Phone Number format 6
extracting data from one format to a different format... 2
format string 2
format cell with multiple formats for telephone numbers 1
custom telephone number format 2
Countif(len(Range)>4) 2

Top