WPS Table Tutorial: Converting date formats

Mr Wu is an information administrator at a middle school in Beijing and often spends a lot of time dealing with various information data. My biggest headache is that the teacher sent the student birth date data form for each class, "Mr. Wu said," because the format of these date data is not uniform and needs to be manually adjusted to the format accepted by the database. ”

As an information manager for a school or other unit, you may encounter problems similar to Mr. Wu, and often receive data in different formats, such as "1998.12.13,19981213,1998 12 13 ..." and the database only accepts the 1998-12-13 type of date. So what to do next, the WPS table can easily help you to deal with these annoying dates, and then we come together to practice it.

The data is sorted by date and centralized in the same format.

Two, use the custom format function to handle "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):

Iii. dealing with the 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.