Converting data in column to Phone Format
I have had to do Social Security numbers once and saved this in case I had to
do it again!
On the Format menu, click Cells.
On the Number tab, click Special in the Category list.
In the Type list, click Zip Code, Zip Code + 4, Phone Number, or Social
Security Number.
Hope it helps!
|