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)
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"April" wrote:

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.
--
BDW