Home >Topics >excel >How to convert date to year month day format

How to convert date to year month day format

藏色散人
藏色散人Original
2020-04-12 11:37:2117880browse

How to convert date to year month day format

How to convert date into year-month-day format

As shown in the picture, it is a group of date data. Now we need to The date is converted into the format of month and day. The specific operation is as follows

Recommended: "excel tutorial"

How to convert date to year month day format

Select column D and click Right-click the mouse, as shown in the picture, and find "Format Cells, as shown in the picture

How to convert date to year month day format

Click "Format Cells," and find "Number" in the pop-up dialog box , as shown in the picture

How to convert date to year month day format

Under the "Number tab, find "Date", and select "March 7, 2001" under the type, as shown in the picture

How to convert date to year month day format

Click "OK" and you will find that the date is automatically converted to year, month and day format, as shown in the picture

How to convert date to year month day format

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

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn