Use the TEXT function (and don't bother using the CONCATENATE function, you
can use &s instead):

=J5&TEXT(K5,"mmddyy")

If you indeed want a comma separating them (your formulas below wouldn't
show a comma), you can stick it right before the mmddyy part.



"AYPCN" wrote in message
...
J5
HFUP,

K5
031005

L5
=CONCATENATE(J5,K5)
HFUP,38421 how can i get this date corrected to show what is in K5 tryed
formating cell to mmddyy

so the final resualt should show
HFUP,031005

thanx