Inserting dashes to an existing number

D

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
 
D

Don Guillett

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

Frank Kabel

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

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
 
Top