Date CONCATENATE
 

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

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

Hi

try

=J5 & TEXT(K5,"mmddyy")

Cheers
JulieD

"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