find and replace

[Stephanie]

I have telephone numbers in this format 1234567899 and
want to replace them in this format 123-456-7899. Is
there any way to do that?

 

[Dan E]

Stephanie,

I'm not sure that find replace is necessary, format the cells as custom and type in 000-000-0000

If that doesn't work for you,
=LEFT(A1,3) & "-" & MID(A1,4,3) & "-" & RIGHT(A1,4)
in an adjacent column and copy down

Dan E

 

[Jay]

I have telephone numbers in this format 1234567899 and
want to replace them in this format 123-456-7899. Is
there any way to do that?

Format >> Cells >> Special >> Social Security Number