WPS Office

Free All-in-One Office Suite with PDF Editor

correct-icon

Edit Word, Excel, and PPT for FREE.

correct-icon

Read, edit, and convert PDFs with the powerful PDF toolkit.

correct-icon

Microsoft-like interface, easy to use.

Free download

Windows • MacOS • Linux • iOS • Android

banner

How to convert date to text in excel(The Easiest Method)

August 18, 2022
3.9K Views

When using Excel, we commonly work with numbers, text, and date format. Excel is solely a numerical programme that gives us a chance to learn about how to convert date to text in excel. The values will be shown using the formatting you supply. For instance, in Excel, the date and time are maintained as numbers and structured to show readable values.

You can find the process of how to convert date to text in excel, down below.

How to convert date to text in excel online, 2016 and 2019:

1.Look at the example below; the value 43388 is located in cell A1. However, the data will show as 15-10-2018 if we format it as a date.

2.Select Format Cells from the context menu when you right-click on the cell.

3.Select the date using the options that are shown below.

4.The result will now be as displayed below.

5.As a result, Excel will present the numbers with the formatting we choose.

How to convert date to text using text function in excel:

1.We will change the integers in cells A2 to A10 below into dates and place those dates in cells B2 to B10.

2.To convert them to date format, enter the following formula in cell B2.=TEXT(A3,”dd-mm-yyyy”)

3.Type in the formula, then drag it.

Using the Text to Column option, convert dates to text in excel:

1.If we don't like equations, we can use Excel's TEXT TO COLUMN OPTION to convert dates to text format. Assume that data is present in cells A2 to A8.

2.It needs to be changed to text format right now.We must first choose the complete column that we want to transform.

3.Next, we must choose Data > Convert Text to Columns Wizard in Excel.

4.A decision on the delimiter must be made before moving on to step 3.Uncheck every box in the recently opened pop-up window, then click Next to proceed.

5.The TEXT option must be selected in the next dialogue box. Next, enter =$B$2 as the target cell's value, and click Finish.

6.As a result, it will instantly switch to text format.

Where in Excel can you convert a date to text:

1.Now let's have a look at some Excel text conversions of dates.When converting a date to text in Excel, we must utilize the TEXT function. Time and date are kept in Excel as numbers, as was already mentioned. But sometimes we might have to show it as a text string. In these cases, the TEXT function can be utilized.

There are two components to the TEXT function: VALUE and FORMAT TEXT.Value: The value is what has to be converted. There is only the selected cell. That could be a numeric value or a numeric reference cell.Text in the required format is sent to the cell, or the target cell.

Note: This above written article is an attempt to show you how to convert date to text in excel online, 2016 and 2019, in both windows and mac.You just need to have a little understanding of how and which way things work and you are good to go. With having this basic knowledge or information of how to use it, you can also access and use different other options on excel or spreadsheet. Also, it is very similar to Word or Document. So, in a way, if you learn one thing, like Excel, you can automatically learn how to use Word as well because both of them are very similar in so many ways. If you want to know more about WPS Office, you can download WPS Office to access, Word, Excel, PowerPoint for free.                                  

15 years of office industry experience, tech lover and copywriter. Follow me for product reviews, comparisons, and recommendations for new apps and software.