Format zeros not to truncate when concatenating two columns

[gmryden]

My goal is to take a date, 02/05/07 for instance, and reflect the data as 0205. I am able to break apart the 3 componets but when I conatenate the first two columns the leading zeros will truncate so my result is 25, or 205 instead of 0205. I can't seem to figure out how to make the zeros show regardless.

 

[Jonmo1]

Welcome to the board,

Try

=TEXT(A1,"DDMM")

 

[barry houdini]

hello gmryden, Welcome to MrExcel

Does 02/05/07 represent 2nd May or 5th Feb?

If the former then with date in A1

=TEXT(A1,"ddmm")

or for the latter

=TEXT(A1,"mmdd")