I've been using the concatenate function in Excel to make text strings out of
multiple cells, and I'm trying to do so for cells that include dates and
times. When I concatenate these cells and they are converted to text, I get
the general number format for the dates and times instead of the formatted
date or time that I've entered. Is there a way to avoid this?