Try this:

=TEXT(A1,"000")&"-"&TEXT(B1,"00")&"-"&TEXT(C1,"00")

Hope this helps.

Pete

On Aug 6, 3:20 pm, Amatus39
wrote:
I am trying to combine columns into one so that I can have one column with
the numbers I want. I have three different sets of number that I want in one
column seperated by a "-" I know how to do this except I can't get the
formula to copy the number formats I have in the cells it is combining. For
example, in one cell I have 001 then the next 02 then 01. When I try to
combine, excel combines this as 1-2-1. I want the "0's" in the number! I
want the combination to read 001-02-01. How do I do this? Any help would be
great!