How to batch convert date formats in excel

How to batch convert date formats in excel: First select the dates that need to be converted and open the column sorting dialog box; then select the column sorting method as [Fixed Width] and determine the dividing line; finally set the [Column Data] Format] can be date.

How to batch convert date formats in Excel:

1. Select the dates to be converted.

Use the mouse to select the date whose format needs to be converted. Cross-regional selection is allowed here.

#2. Open the column sorting dialog box.

Click "Data" → "Column Sort" on the top menu bar → open the "Text Sort Column Wizard" dialog box.

3. Select the column sorting method as "Fixed Width".

Check the radio button in front of "Fixed Width" and click "Next".

4. Determine the dividing line.

Click once after the last digit of the date. A vertical line will appear. Click "Next".

#5. Set the "Column data format" to date.

Check the radio button in front of "Column Data Format" → "Date" and select the "YMD" format in the drop-down menu.

#6. Complete the date format conversion.

At this point you can see that the date in the Excel workbook has changed to the format of "2018/02/14".

Related learning recommendations: excel basic tutorial

The above is the detailed content of How to batch convert date formats in excel. For more information, please follow other related articles on the PHP Chinese website!