C
Chris Korinek
I have a use for concatenated streams;I have a project
log in Excel where the job no., date, and other info are
entered into separate fields. Then, I concaenate the
information into one field and copy and paste this into
Word. This works well, except that I cannot get the date
into the concatenated stream in the correct format. I
seems to come in under the numerical form. Here is the
example for a stream pulled from fields As, A3, and A4:
=CONCATENATE("Stream population for ",A2," ",A3,"
is ",A4,"/mile")
If A3 is a date formatted field (like mm/dd/yy) please
comment on how to make it show up in mm/dd/yy inside the
concatenated stream.
Thank you.
Chris Korinek
log in Excel where the job no., date, and other info are
entered into separate fields. Then, I concaenate the
information into one field and copy and paste this into
Word. This works well, except that I cannot get the date
into the concatenated stream in the correct format. I
seems to come in under the numerical form. Here is the
example for a stream pulled from fields As, A3, and A4:
=CONCATENATE("Stream population for ",A2," ",A3,"
is ",A4,"/mile")
If A3 is a date formatted field (like mm/dd/yy) please
comment on how to make it show up in mm/dd/yy inside the
concatenated stream.
Thank you.
Chris Korinek