Forum Discussion
TextJoin
When using TextJoin, how do I keep the data format from the referenced cell? For example, in the formula, I enter a cell reference that has data in a date format, but the resultant string returns a general number.
IanNoy You would have to do it this way:
