Concatenate error??

Hi all,

I have something which is driving me crazy, I am trying to add a week number to a year number.
I need the result to always contain the same numnber of characters.
My week numbers are 1-52 and years 2012,2013 etc..
I custom format the week number cell so I always get two digits, 1 becomes 01. and then concatenate year number,weeknumber.
The concatenate works but excel strips the leading zero from the week number so instead of 201201, I get 20121....Arrrgghgghhhh!!

anyone know why or how to solve?

Thanks

Mike

=TEXT(A1,"0000")&TEXT(B1,"00")


Regards, TMS


Edited: year and week number wrong way round

Perhaps something like =A1&text(A2,"00") where A1 contains year and A2 the week nr

Perfect, Thank you both.

They both are perfectly acceptable..

thanks

Mike

You're welcome. Regards, TMS