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 ...
- Thank you, that gives the result of 2019-01-01T0. Maybe the issue is more within the time column of 0:00:00.
The last bit can't be 0 because the header of the column says "Entered text".
So it should produce 00:00:00.
If your intention was to mislead the helpers and it's really a time value then use the TEXT() function.
TEXT(C2,"hh:mm:ss")
