How to put "-" between numbers

[sporitus]

Hello experts:

I have a column with numbers like this:

123446367
354624634
3464363
34612311
374347

and i need to put "-" in each number after first 4 digits. Like this:

1234-46367
3546-24634
3464-363
3461-2311
3743-47

Please advice, how i can do this ?

Thanks

Ivan

 

[Smitty]

How's this:

=LEFT(A1,4)&"-"&RIGHT(A1,LEN(A1)-4)

HTH,

 

[Scott Huish]

Perhaps:
=REPLACE(A1,5,0,"-")

 

[sporitus]

Thanks a lot
both solutions work