Copper Contributor

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.

1 Reply

@IanNoy You would have to do it this way:

Screenshot 2024-03-06 at 07.02.33.png