concatenate and add "/"'s

[beancounter]

Does anyone know of a way to add /'s to a concatenate formula? For instance column H = 06, column I = 29, column J = 1994, the formula in column K = concatenate(h2,i2,j2) to get 06291994. I would like to have the result be 06/29/1994.

Thanks,
John

 

[Jonmo1]

Why not make it an actual date..

=DATE(J2,H2,I2)

But to technically answer the question...

concatenate(h2,"/",i2,"/",j2)

or

=H2&"/"&I2&"/"&J2


Hope this helps..

 

[Norie]

John

Do you actually want a 'real' date or the text?

Real date:

=DATE(J2, H2, I2)

Text:

=H2&"/"&I2&"/"&J2

 

[beancounter]

That's it!

I'm using the concatenate(h2,"/",i2,"/",j2) and it works perfectly.

thank you