I'm trying to figure out "how to" maintain the date format when I concatenate a date formatted cell with a nondate formatted cell.
Result: The Date Format Is Lost
Desired Result: I had to convert Date format to Text Only
I'm trying to figure out "how to" maintain the Date Format while combining two cell values. Any ideas?