text function – convert numeric cell values to text

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

Text1 Text2

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.


Get more great content from Rousseau Associates

Start your project with us today

Call +44 (0)1757 269461

Discuss your requirements today