formula to format

R

Rick

I have a colume of phone numbers formatted as follows (123)123-1234. However
I need a formula to make a new colum exchanging the format to 123-123-1234.
Is there a way to do this? thanks
 
D

David Biddulph

Are they numbers, displayed with a special format, or are they text strings?
 
B

Bernard Liengme

If they are numbers then you need a format setting not a formula! See
David's reply.

I type 1231231234 into cell
Called up cell format with CTRL+1; opened the Special group and selected
Phone Number
You can get the same effect with custom format:
[<=9999999]###-####;###-###-####
best wishes
 

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

Top