How to unify date formats in WPS tables

ways to unify date formats in a WPS table:

1. Select cell D2 and click Ascending in the toolbar to have all dates grouped together by text date, numeric date, and standard date in the order of three categories. Then right-click the column in column D to select Insert, insert a column after (e column), and select the E column right click to select Format cells to set the appropriate date format as needed (Figure 2). Then you can classify the date for conversion, the standard date does not have to deal with, as long as the text and numerical data of two types of conversion can be.

2. For the first 78.2.3, 2009.1.25 and other text dates, just enter the formula =value in E2 (Substitute (D2, ". ","-"), and then select the E2 cell to drag the Black small square (fill handle) in its lower-right corner to copy the formula down to fill, you can convert the date in column D to the standard date displayed in column E (Figure 3). The function formula represents the D2 content. Replace with-, and then converted to a numeric value. In this case, if you only use the substitute function to replace the date format, although the display is a date but Excel is processing it as text, so it is necessary to convert the value into a numeric value to be treated as a date by Excel.

3. The numeric date format for 20090201, 980201 is also simple, as long as you enter the formula =value (TEXT (D11, "# #00-00-00") in the E-column cell (E11) of the first numeric date. Then select the E11 cell and drag its fill handle to copy the formula down to fill, and convert the date in column D to the standard date displayed in column E (Figure 4). The function formula indicates that the D2 digital content is converted to text in the # #00-00-00 format to 2009-02-01, 98-02-01, and then converts the text to a numeric value using value to make Excel recognize the date.