Merging Number fields together with leading zeros

Okay I have a large excel file that I did not create which we are extracting info form. I need to merge 3 number columns together to produce a combined result. Such as 2007 + 001 + 024 = 2007001024
I tried converting to text but then I lose the leading zeros and I am back where I started. The 3 number columns are actually custom with a format of 0000 000 000.
Is there a way to merge without converting anything to text since the combined number result is actually an identifier for something else? (The numbers range in each column meaning sometimes it can be 3427 989 123 or 1002 001 002) I tried using =CONCATENATE(A1,B1,C1) and =A2&B2&C2 but I still don't the result I need.

Can you upload a sample?

With these values in A1:C1
2004 001 024

This regular formula concatenates them:

Please Login or Register  to view this content.

In that example, the formula returns: 2007001024

Is that something you can work with?

Maybe something like this?

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

Based on your last post it seems that you are satisfied with the solution(s) you've received but you haven't marked your thread as SOLVED. If your problem has not been solved you can use Thread Tools (located above your first post) and choose "Mark this thread as unsolved".
Thanks.

Also, as a relatively new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.