Hi

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

Where B1 is the date cell.

Regards,
Per

"April" skrev i meddelelsen
...
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