concatenate

[April]

i am concatenating several cells. one of the cells has a date - its format
in the cell that i am concatenating is 11/30/03. however, when i concatenate
the cell its format becomes the numerical equivalent of the date 37955. how
can i get around this?

thank you in advance for your help.

 

[Luke M]

you can use the text function like this:
=A2&TEXT(A3,"mm/dd/yy")

Which concatenates A2 with the date in a3 (formatted as in your example)

 

[Per Jessen]

Hi

=A1 & Text(B1,"mm/dd/yy") & C1

Where B1 is the date cell.

Regards,
Per

 

[April]

Thanks to both Luke and Per. This works perfectly

 

[april]

i sent a thank you for the help yesterday (all the solutions worked).
however, my email seemed to be stalled so i don't know if the thank you was
sent or not. if not, a big thanks again.

 

[Per Jessen]

Hi April

Thanks for your reply, I am glad to help.

Your post was sent yesterday.

/Per