Inserting dashes to an existing number

[dinahrose]

Hi,

I am trying to create a formula that will divide this ten digit numbe
into the following dashes.

Here is the number 1234000999 I need the dashes to be inserted in thi
format 1234-000-999.


What is the appropriate formula.

Thanks for your help.
Dinahros

 

[Don Guillett]

Why not just custom format
right click on selection>format>number>custom>
####-###-###

 

[Frank Kabel]

Hi
in addition to Don if you need a formula try:
=TEXT(A1,"0000-000-000")
in an adjacent cell

 

[Alex Delamain]

Custom format is the simplest but if you really need to add the - the
try this

=LEFT(a1,4)&+"-"&+MID(a1,5,3)&+"-"&+RIGHT(a1,3