Hi all,
How do you show a date in a readable format in a cell where two fields are concatenated.
Example:
- in cell A1 is a project name --> TestProject
- in cell B1 is a timestamped date --> 20-05-2021 15:35:01
- in cell C1 I want to concatenate both --> =A1&" ("&B1&")"
But the result is unreadable. It shows TestProject (44336,6493171296). I would like it to show me TestProject (20-05-2021 15:35:01)
Thanks for any help!!
Pat.
How do you show a date in a readable format in a cell where two fields are concatenated.
Example:
- in cell A1 is a project name --> TestProject
- in cell B1 is a timestamped date --> 20-05-2021 15:35:01
- in cell C1 I want to concatenate both --> =A1&" ("&B1&")"
But the result is unreadable. It shows TestProject (44336,6493171296). I would like it to show me TestProject (20-05-2021 15:35:01)
Thanks for any help!!
Pat.