Date spilt into four cells

[hyyfte]

Now I have to go from date into four cells...

I have:
A5: 09/25/04

I need:
D11: 0
E11: 9
G11: 2
H11: 5
J11: 0
K11: 4


My problem:
Instead of pulling the month as 09, it is pulling 38.
09/25/04 = 38255

What I'm using:
=MID($AP$5*100,1,1)+0
Is there a macro or formula to keep the numbers as a date instead o
changing them back to a number

 

[Don Guillett]

this should help. Gets 09
=LEFT(TEXT(D1,"mm/dd/yy"),2)