Telephone Numbers

Kennel slave · Jan 8, 2008

How do I format an entire column to automatically convert the number:
1236785555 to appear (123) 678-5555?

CLR · Jan 8, 2008

Highlight the cells, then do Right-click > FormatCells > NumberTAB > Special

PhoneNumber > OK

Vaya con Dios,
Chuck, CABGx3

Kennel slave · Jan 8, 2008

Thanks, Chuck! It worked!

CLR said:
Highlight the cells, then do Right-click > FormatCells > NumberTAB > Special

Vaya con Dios,
Chuck, CABGx3

CLR · Jan 8, 2008

You're welcome, thanks for the feedback.
(I used to raise Greyhounds in a former life)

Vaya con Dios,
Chuck, CABGx3