Excel date format Conversion

Source: Internet
Author: User

Date format conversion format one: When entering 20120920, automatically converts to 2012-09-20

First open the Excel table, select the cells you want to convert, and then click the right mouse button to select Format cells in the list that pops up. As shown in the figure:

In the pop-up window, click the "Number" button above, select the "Custom" option in the list, and then enter the "0000-00-00" format in the Type input box, click OK. As shown in the figure:

Display format, let's take a look at the format you just set, select the cell that you just set, type 20120920, and then enter. As shown in the figure:

Computer Tutorials

Date format conversion format two: When entering 20120920, automatically convert to September 20, 2012

The steps are similar to the above, but enter the "### #年 # #月 # #日" format in the Type input box, and then OK. As shown in the figure:

Display the format, enter 20120920 in the cell that we just set up, and then return. As shown in the figure:

Date format conversion Format three: input 20120920, automatically converted to the 0-year zero nine months of the 0

The steps are similar to the above, but enter the [dbnum2]0000 year 0 days] format in the Type input box, and then determine. As shown in the figure:

Display the format, enter 20120920 in the cell that we just set up, and then return. As shown in the figure:

Date format conversion Format four: input 20120920, automatic conversion to 2012 9 months two 0 days

Enter the "[dbnum1]0000 Year 0 days" format in the Type input box, you can convert to format four, this is the same as the above, I believe I will not teach you all.

Related Article

E-Commerce Solutions

Leverage the same tools powering the Alibaba Ecosystem

Learn more >

11.11 Big Sale for Cloud

Get Unbeatable Offers with up to 90% Off,Oct.24-Nov.13 (UTC+8)

Get It Now >

Alibaba Cloud Free Trial

Learn and experience the power of Alibaba Cloud with a free trial worth $300-1200 USD

Learn more >

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.