display leading zeros in a character string

[ibsoxfan]

Hello all,

I have a code which displays the values of R2, S2, T2, and U2 in one cell (J2). R2, S2 and U2 are all letters, but T2 is a 2 digit number. If there is a leading zero in T2, then in the display of J2, the leading zero is gone. so if the value of R2 is K, S2 is M, T2 is 01 and U2 is S, then I would want it to display KM01S, but it is only displaying KM1S. Thank you for your help and I hope that I have given you enough information!

[Pete_UK]

Do it this way:

=R2 & S2 & TEXT(T2,"00") & U2

Hope this helps.

Pete