The TEXT function enables values such as dates, time and values to be interpreted as text values. This can be particularly useful when using a lookup function (VLOOKUP, MATCH, etc) that requires the lookup value to be in a specific format.
The following example will demonstrate how to convert a date stamp value into a text date value and a text time value.
Enter =NOW() into a cell A2 to return the current date and time. In order to see both the date and time the cell will need to be formatted to display both
In a cell C2 enter =TEXT(A2,”yyyy, mmmm, d”) to return the date element in a text format
In cell C3 enter =TEXT(A2,”hh:mm:ss”) to return the time element in a text format.