Change 1234567890 to 123-456-7890
That did it. Thank you so much.
"Peo Sjoblom" wrote:
I assume you meant 10 digits?
Select an empty cell, do a custom format of
<=9999999]###-####;(###) ###-####
copy the cell, select the range where you want these
phone numbers and do editpaste special and select add
Now try it
--
Regards,
Peo Sjoblom
"ann" wrote in message
...
I am trying to do the opposite for what everyone else has been asking for
help in resolving a phone number issue.
I want to key in each cell nine digits and have it automatically format
into
a phone number format as shown in my subject. I have gone to
Format/Cells/Number to select the Special Type for Phone numbers, no luck.
The won't change. Then I thought I would create a custom format of both
###-###-#### and (###)###-####, once again no luck. I have tried
everything
short of pulling out my hair. Does any one have any suggestions?
|