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

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

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

Thanks to both Luke and Per. This works perfectly
--
BDW


"Luke M" wrote:

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

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


"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

Hi April

Thanks for your reply, I am glad to help.

Your post was sent yesterday.

/Per

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


"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