Concatenate Problem

[Eb0la11]

I have 3 columns of data, A, B, C.

A has - 00061
B has 003290
C has 9610

I was trying to use concatenate with periods between each reference to the cells noted above to get 00061.003290.9610 as the result in column D. It results in 61.3290.9610 even when I assign custom formatting as 00000.000000.0000 or #####.######.####.

Anyway I can get it to display as desired with quick resolve?

 

[Joe4]

Use the TEXT function to keep the leading zeroes.

=TEXT(A1,"00000") & "." & TEXT(B1,"000000") & "." & TEXT(C1,"0000")