How to enter date separator in Excel?

Steps to enter date separator in excel:

1. Open the workbook to be edited and select the cell range to be edited. .

#2. Select the "Data" tab and click the "Column" button in the "Data Tools" group.

#3. In the pop-up dialog box, select "Delimiter" under the "Original Data Type" column and click "Next".

#4. The "Tab key" option under the "Delimiter" column is checked by default. Ignore it and click "Next" directly.

5. Select the "Date" option under the "Column Data Format" column and click the "Finish" button.

#6. Add delimiters to everything in the table, as shown in the figure.

Recommended tutorial: "excel tutorial"

The above is the detailed content of How to enter date separator in Excel?. For more information, please follow other related articles on the PHP Chinese website!