Insert "-" in text "1234567890" to have a output like this"123-456-7890"

[Alwyn]

This is a very simple requirement. Can anyone help me with this ASAP.

What i need:- Insert "-" in text "1234567890" to have a output like
this"123-456-7890"

Thanks in advance!!!

Regards,

Alwyn

 

[Guest]

Change the format of the cells to "Custom" and enter 000-000-0000

 

[Guest]

That is the easiest solution to change the output of the cells. If you want
to actually change the content of the cells you will need to create a dummy
column and use the formula

=LEFT(A1,3)&"-"&MID(A1,3,3)&"-"&RIGHT(A1,4)

After copying this formula down the list, you can then copy the column and
paste special selecting "values".

 

[Ron Rosenfeld]

This is a very simple requirement. Can anyone help me with this ASAP.

What i need:- Insert "-" in text "1234567890" to have a output like
this"123-456-7890"

Thanks in advance!!!

Regards,

Alwyn

=TEXT(1234567890,"000-000-0000")

--ron