I have the following code:

dd = Right(sd, 2)
mm = Mid(sd, 3, 2)
yy = Left(sd, 2)
temp = dd & "/" & mm & "/20" & yy
temp = Format(temp, "dd/mm/yy")
Cells(3, "c").Value = temp

where sd is s string which contains a date in the format 031124.

I want the value to appear in cells(3,"c") in the format 24/11/03.

No matter what I do, the format always ends up as 11/24/2003.

Is there a way of making excel do what I want, not what it wants?
Thanks
Chris