Any Way to Format this Data in Excel? 1

[txdave35]

Hey guys,

I am building an Excel spreadsheets that directly pulls data from a SQL database. One field is a phone number field. In the database, the phone number appears without dashes.

I would like Excel to auto format the number and put dashes.

Ex. 1235555 displays as 123-5555. Any way to do this?

 

[txdave35]

Disregard, just figured it out.

 

[SkipVought]

txdave35,

I notice that over the past 8 months, you have posted 52 threads and have received many good tips related to your stated needs. Yet, you have responded NOT ONCE, to
[blue]
Thank Tek-Tip Contributor
for this valuable post![/blue].

The [purple]little purple Stars[/purple] accomplish several important things.

First, it gives positive feedback to contributors, that their posts have been helpful.

Second, it identifies threads as containing helpful posts, so that other members can benefit.

Third, it identifies the original poster (that's YOU, BTW), as a grateful member, that not only receives, but is willing to give tokens of thanks.

Finally, it also helps other members browsing the forum, to see solutions. So if you found a solution on your own, why not share that with all of us here at Tek-Tips. That would be appreciated.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}