concatenate

  • Thread starter Thread starter April
  • Start date Start date
A

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.
 
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)
 
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.
 
Hi April

Thanks for your reply, I am glad to help.

Your post was sent yesterday.

/Per
 
Back
Top