Convert date to text in excel

You can use the following formula to convert time to text in Excel:

This particular formula converts the time in cell A2 to text.

The following example shows how to use this formula in practice.

Example: Convert Time to Text in Excel

Suppose we have the following column of times in Excel:

Currently each of these times is not stored as text.

We can verify this by typing the following formula into cell B2:

This formula returns FALSE, which tells us that the time value in cell A2 is not currently recognized as text.

Suppose we would like to convert each time in column A into text.

We can type the following formula into cell B2 to do so:

We can then click and drag this formula down to each remaining cell in column B:

Each cell in column B now contains the corresponding time in column A formatted as text.

We can verify that each cell in column B is text by typing the following formula into cell C2:

We can then click and drag this formula down to each remaining cell in column C:

convert time text to number excel

excel convert time to text without losing format