If you are looking for software to use, go to Huajun Software Park! software release
Location: front pageTutorial strategyTutorialComputer software tutorials Use WPS to process...

How to use WPS to process date data format

author: Date: 2024-05-11

WPS Office
WPS Office-12.1.0.18608

Office software Storage size: 236.4 MB Time: 2021-12-08

Software introduction: The official version of WPS Office is a free office software launched by Kingsoft. The software is compact and quick to install, has strong compatibility, and takes up very little memory...

Download now


​ ​ 1. Sort the data by date so that data in the same format are concentrated with each other.

Sort data by date

Sort data by date

​ ​ 2. Use the custom format function to process the "19981213" type date.

Execute "Format" → "Cells", in the "Number" tab of the pop-up "Cell Format" dialog box, click "Category (C):" → "Custom", under "Type (T):" Enter "0000-00-00" (without quotation marks) and confirm.

Use custom format

Use custom formats

3. Process various delimited dates.

​ ​ Next, just use the find and replace function to replace various separators with the standard date separator: "-". You can easily adjust the date format uniformly.

Related articles