How to convert date to string?

Question

excel

I want to insert data from excel into database. When I want to insert a time value into a formula, excel converts it to a number.

When I try to convert to text, excel first converts to a number, and only then to text

. Can this be avoided? And what does the converted number mean? Share of the day?

Answer 1

You can convert the field to text "by template"
You can use any template