Date CONCATENATE

[Guest]

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

 

[Dave R.]

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.

 

[JulieD]

Hi

try

=J5 & TEXT(K5,"mmddyy")

Cheers
JulieD