Go Back

Convert date to text

Figure 1. Convert Date to Text.

If we want to convert a calendar date in its number format, to text format, we are going to utilize the Excel TEXT Function.

Generic Formula


  • date is the number value we want to convert.
  • format is the pattern in which we want the resulting text string to appear.

Time and dates are originally stored as serial numbers in Excel before they are transformed into values that can be read by us.

How to use the Excel TEXT Function.

We will now demonstrate how we can use the Excel TEXT Function to convert a date in number format into text. .

Figure 2. Convert Date to Text in Excel.

In the example illustrated above, our purpose is to convert the date in cell A2 to a text string format.

We entered the formula for the TEXT Function into cell B2.

The Excel TEXT Function returned the text string date format in cell B2.

The TEXT Function can be used for converting numeric values or dates in a fixed format.

Figure 3. Final Result.

Instant Connection to an Expert through our Excelchat Service:

Our live Excelchat Service is here for you. We have Excel Experts available 24/7 to answer any Excel questions you may have. Guaranteed connection within 30 seconds and a customized solution for you within 20 minutes

Did this post not answer your question? Get a solution from connecting with the expert.

Another blog reader asked this question today on Excelchat:
Here are some problems that our users have asked and received explanations on

How do I convert text to date format?How do I convert text to date format?How do I convert text to date format?How do I convert text to date format?
Solved by X. D. in 26 mins
How do I convert text to a date format?
Solved by M. D. in 13 mins
help me to convert text value into date and time value
Solved by G. U. in 29 mins

Leave a Comment