format formula

[kod2th3e]

I am using the following formula to determine the week and year of a particular cell:

=(WEEKNUM(C2))&(YEAR(C2))

In cell C2 the date is 2/23/11 so in the cell where I have this formula I get an answer of 92011. This is fine however I was wondering if anyone knows how or if it is possible to have the format of this cell be WWYY. So, instead of displaying 92011 it would be 0911. Thoughts? Any advice/help would be appreciated, thanks for looking.

-Cody

 

[VoG]

Try

=TEXT(WEEKNUM(C2),"00")&TEXT(C2,"yy")

 

[kod2th3e]

That did the trick, thank you kind sir.