How to convert date to text in Excel

Excel stores and analyzes data of all types. Most of the data consists of dates. Dates are presented in numeric form in excel worksheet by default. Excel users can convert this kind of dates in text manually. This method is applicable for data consisting of limited amount of dates. If the data consists of multiple dates, then it becomes very arduous for excel users to convert it in text.

Excel has solved this problem of the users by installing a unique feature of converting numeric dates in text. This feature includes certain methods and techniques which can easily convert the numeric date present in your data in text form. In this article we will discuss such methods which will enable the users to convert date into text. These methods are applicable for 2016\2019\mac\online versions.

How To Convert Date To Text In Excel Using Formula?

The most common method of converting the numeric dates in your data to text form is by using formula. Using formula for converting dates to text is a quick and easy method. Most of the excel users changes the numeric dates in text form by simply applying the formula. The steps of converting date to text are given below. This method works on 2016\2019\mac\online versions.

1. First we will select the cell containing numeric date. In this case we will select cell A2.

2. Then we will add the formula=TEXT(A1,mm/dd/yyyy)in the formula tab.

3. After that we will press enter key which will result in change of numeric date to text in the selected text.

This technique works on 2016\2019\mac\online versions.

How To Convert Date To Text Using Text To Column?

We can change the date into text form by using another method which is Text to Column.This method is a little time taking but can convert all the dates in a data to text. The steps of this method of changing dates to text are mentioned as follows. This technique is applicable for 2016\2019\mac\online versions.

1. First we will select the cell containing the date we want to convert in text form

2. Then we will go to data tab and select the option of text to column.

3. Then we will click on the option of delimited and will uncheck all the boxes.

4. After that we will click the option of next and then we will enter the destination of the converted date.

5. Then we will click finish which will result in converting of date to text.

This method works with 2016\2019\mac\online versions.

How To Convert Data to Text By Using Copy Paste Method?

One of the simple way of converting date to text is by copy pasting. This method consists of following steps which are applicable for 2016\2019\mac\online versions.

1. First we will select the cells consisting of the numeric date.

2. Then we will copy the dates and paste them on the notepad where they will automatically change to text.

3. Then we will paste this text in the excel worksheet and we will click the option of text from down drop. The result will be conversion of dates to text.

This process works on 2016\2019\mac\online versions.

Did you learn about how to convert date to text in excel using different methods? You can follow WPS Academy to learn more features of Word Document, Excel Spreadsheets, and PowerPoint Slides.

You can also download WPS Office to edit the word documents, excel, and PowerPoint for free of cost. Download now! And get an easy and enjoyable working experience.