Excel table date format conversion

In Excel we often enter various dates, but sometimes in order to save time we may enter a less formal, at this point you can set the date format in Excel automatic conversion function, can easily convert to the format you want. This tutorial will give you a detailed explanation of some of the commonly used in Excel input date conversion methods!

The first date conversion: input "20110606" when the automatic conversion to: 2011-06-06!

First, select the cell, then right-click Select Format cell, click Custom in the category on the left, and then type "0000-00-00" in the right side to OK.

The second date conversion: input "20110606", automatically converted to "June 06, 2011"!

Step above, just enter "### #年 # #月 # #日 in cell format" type "OK.

The third type of date conversion: input "20110606", converted to "two 0 0 years 0 months 0 Land Day"!

In the cell format custom type, enter [dbnum2]0000 year 0 days]

Fourth date conversion: Convert "20110606" to "June 2010 0 6th"!

In "type" enter "[dbnum1]0000 Year 0 days", OK!)

Note : More wonderful tutorials Please pay attention to the triple computer tutorial section, triple Computer office group: 189034526 welcome you to join