ExcelBanter - Telephone Numbers

ExcelBanter (https://www.excelbanter.com/)

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - Telephone Numbers (https://www.excelbanter.com/new-users-excel/172124-telephone-numbers.html)

Kennel slave

Telephone Numbers

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

CLR

Telephone Numbers

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

Vaya con Dios,
Chuck, CABGx3

"Kennel slave" wrote:

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

Kennel slave

Telephone Numbers

Thanks, Chuck! It worked!

"CLR" wrote:

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

Vaya con Dios,
Chuck, CABGx3

"Kennel slave" wrote:

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

CLR

Telephone Numbers

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

Vaya con Dios,
Chuck, CABGx3

"Kennel slave" wrote:

Thanks, Chuck! It worked!

"CLR" wrote:

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

Vaya con Dios,
Chuck, CABGx3

"Kennel slave" wrote:

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

All times are GMT +1. The time now is 10:04 PM.