How to Convert Date to Text YYYYMMDD (3 Quick Ways)

Get FREE Advanced Excel Exercises with Solutions!

In Excel, the date and time are stored as numbers. This allows the user to perform calculations with these dates and times. However, you might want these dates to behave like text at times. You’ll need to know how to convert a date to text in these situations. Assume you have a set of dates in mmddyyyy format that you wish to convert date to text yyyymmdd format, as seen in the screenshot below. In this article, I’ll show you how to rapidly convert date to text yyyymmdd format.

Convert Date to Text YYYYMMDD


How to Convert Date to Text YYYYMMDD in Excel: 3 Ways

In this section, we will discuss three different methods to convert date to text yyyymmdd.

Method 1: Use TEXT Function to Convert Date to Text YYYYMMDD

The TEXT function converts a numeric number to a text string and displays it in the format you define.

Here’s an example of how dates and text can be blended. The dates lose their formatting and appear as digits in the merged text.

Let’s first see how the formula works for the TEXT function.

=TEXT(value, format_text)

Arguments Explanation:

Arguments  Required/Optional Explanation
value Required The number you’d want to convert to text. This can be a number, a cell reference to a number, or a formula result with a number.
format_text  Required The format in which you prefer the number to be displayed Within double quotations, the format must be given.

Now we will apply this function to complete our task. Let’s follow the instructions below.

Step 1:

  • Select a blank cell next to your date, for instance, C5.
  • Type the following formula.
=TEXT(B5, "yyyy-mm-dd")

Convert Date to Text YYYYMMDD

Step 2:

  • Press Enter.
  • Then drag the AutoFill handle over the rest of the cells.

Use TEXT Function to Convert Date to Text YYYYMMDD

Read More: How to Convert Date to Text Month in Excel


Method 2: Apply Format Cells to Convert Date to Text YYYYMMDD

If you’re not a fan of Excel formulas, there is another cool way to quickly convert date to text in Excel – the Format Cells feature. Excel’s Format Cells feature can quickly convert date to yyyymmdd format.

Step 1:

  • Select the dates you want to convert to yyyy-mm-dd.
  • Right-click to show the Context Menu.
  • Choose Format Cells.

Use TEXT Function to Convert Date to Text YYYYMMDD

Step 2:

  • In the Format Cells dialog, under the Number tab, select Custom from the Category list.
  • Type yyyy-mm-dd into the textbox of type in the right section.

Apply Format Cells to Convert Date to Text YYYYMMDD

Step 3:

  • Press Enter to see the results.

Apply Format Cells

Read More: How to Convert Date to Number in Excel 


Method 3: Use the TODAY Function to Convert Date to Text YYYYMMDD

If you wish to convert the current date to text, use the TEXT function in Excel in conjunction with the TODAY function, which returns the current date. The following formula describes how the function works,

=TEXT(TODAY(), “yyyy-mm-dd”)

Steps:

  • Select a blank cell.
  • Type the formula.
=TEXT(TODAY(), "yyyy-mm-dd")

Use TODAY Function


✍ Things to Remember

✎  Make sure your values are formatted as Date. It will not change into yyyymmdd or any format until the value is in Date format.

✎  The first clue that indicates a date formatted as text is the TEXT formula, which is oriented to the left. Aside from cell alignment, there are a few more signs in Excel that might help you distinguish between dates and text strings.


Download Practice Workbook

Download this practice workbook to exercise while you are reading this article.


Conclusion

To conclude, I hope this article has given you some useful information about how to apply the Text function and Format Cells to convert date to text in Excel. All of these procedures should be learned and applied to your dataset. Take a look at the practice workbook and put these skills to the test. We’re motivated to keep making tutorials like this because of your valuable support.

If you have any questions – Feel free to ask us. Also, feel free to leave comments in the section below.


Related Articles

What is ExcelDemy?

ExcelDemy Learn Excel & Excel Solutions Center provides free Excel tutorials, free support , online Excel training and Excel consultancy services for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Bhubon Costa
Bhubon Costa

Myself, Bhubon Costa, an engineer, is currently employed with Exceldemy as an Excel & VBA Content Developer. I appreciate solving analytical difficulties, finding practical answers, and, for the most part, I enjoy taking on new tasks. I write articles on Exceldemy about various ways to get out of Microsoft Excel's stuck conditions. My passion is to leave my mark on the world through my work and to have an impact on the community who benefit from it.

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo