Telephone Numbers

  • Thread starter Thread starter Kennel slave
  • Start date Start date
K

Kennel slave

How do I format an entire column to automatically convert the number:
1236785555 to appear (123) 678-5555?
 
Thanks, Chuck! It worked!

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

Vaya con Dios,
Chuck, CABGx3
Click to expand...
 
You're welcome, thanks for the feedback.
(I used to raise Greyhounds in a former life)


Vaya con Dios,
Chuck, CABGx3
 
You must log in or register to reply here.

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

How to edit text in colum 3
MS Word 2010 Wildcards 0
Number and text format in the same call 1
Data Matching 2
Summing the same column from many sheets with specific Row ID numbers 11
Mail Merge and Access format of telephone number 2
Building Columns in a Report 3
sumproduct with duplicates in two columns 7

Back
Top