Forum Discussion
Concatenating cells including date cell
Hi, I need a formula that copies an entered date into a specific format that can then be turned into text-field for further calculations. I've found if it's not a text field, whenever I reference it ...
I have been able to use another cell to text cell to get my result of 2019-01-01T00:00:00. However this is stuck in the date format. Is there a way to turn this into text without providing a number format, since none exists for this format?