Combine cells in specific format

[spectraflame]

I have the follow columns of numbers. I need to combine them in a specific format like ###-######-##. How would I go about doing this? In the case where there is only a single number like column c or 5 numbers like column D, a "0" would be the leading number.

Incode Customers 11-16-05.xls
	A	B	C	D
2	20	10048	3
3	80	30134	0
4	160	40424	1
5	160	40424	1
6	160	40454	0
7	160	40454	0
8	160	40454	0
9	160	40475	0
10	170	50022	6
11	170	50022	6
12	180	50377	3
13	180	50377	3
14	300	90291	8
15	300	90296	98
16	300	90302	2
17	300	90307	3
18	330	100295	98
Sheet1

 

[Joe4]

Do you mean a formula like this (for row 2):
=TEXT(A2,"000")&"-"&TEXT(B2,"000000")&"-"&TEXT(C2,"00")

 

[spectraflame]

That is exactly what I was looking for.

Thanks for the quick response.

Matthew