How to change date format to text format

Change method: First select the specified cell, enter "=" in the cell, and click the "fx" button; then select the function "text" and click the "OK" button; then in the "Function Parameters" dialog In the box, select the specified cell for the first parameter, enter "YYYYMMDD" in the second parameter input box; finally click the "OK" button.

The operating environment of this tutorial: Windows 7 system, Microsoft Office Excel 2007 version, Dell G3 computer.

As in this example, the content listed in column A is in date format. It is required to convert the date format in column A into text format and finally list it in column B.

Select cell B2, enter the operator symbol = in the cell, and then click the [fx] button.

The [Insert Function] dialog box pops up:

Select the [All] option in [Or Select Category];

In [ Select function [TEXT] in Select Function. This function converts numbers into text according to the specified numerical format, and then click the [OK] button.

As shown below, the [Function Parameters] dialog box pops up:

Move the cursor to the dialog box behind the first parameter and select the worksheet directly Cell A2 in;

Enter [YYYYMMDD] in the dialog box after the second parameter. After setting the parameters, click the [OK] button.

Return to the worksheet, and through the above steps, the content of cell A2 is converted from date format to text format.

Select cell B2, click the left mouse button and drag the mouse to copy the formula of cell A2 to other cells. In this way, all date formats in column A are converted to text format.

Related learning recommendations: excel tutorial

The above is the detailed content of How to change date format to text format. For more information, please follow other related articles on the PHP Chinese website!