Method of using WPS to deal with date data format

In the administrative work, processing date data, is not particularly distressed, because some people fill in the date as: 1998.12.13,19981213,1998 12 13 ..., in order to standardize and unify the data, we need to organize, but hand to check and tidy up a very waste of time, So, small knitting today to teach you a date data collation method, need to use the software is: Jinshan wps form, now together to practice it!

First, sort the data by date so that the data in the same format is concentrated among each other.

Second, the use of custom format features to deal with the "19981213" type date.

Perform "format" → "Cell", in the Number tab of the Cell Format dialog box that pops up, click Category (C): → Custom, and then type "0000-00-00" (without quotation marks) below by typing (t):

Third, the processing of various delimited dates.

Next, you only need to use the Find and Replace feature to replace the various delimiters with the standard date separator: "-". You can easily adjust the date format.