Set the Current Date Format in WPS Spreadsheets

If your operation system is from United States, United Kingdom, Australia, Canada or New Zealand, WPS Spreadsheets will show the date format corresponding to your computer setting. To set the country-specific current date format, follow the steps below:

Here take the date format of United States and New Zealand as an example.

• Date format of United States

Step 1.Click on "Start menu" and select "control panel" item. Then choose Region and Language option in the dialog box.

Step 2. Choose English(United States) in the Format section under the Region and Language dialog box. Then click Ok button.

Step 3. Open Spreadsheets and press in a cell to view the American date format.

• Date format of New Zealand

Step 1.Click on "Start menu" and select "control panel" item. Then choose Region and Language option in the dialog box.

Step 2. Choose English(New Zealand) in the Format section under the Region and Language dialog box. Then click Ok button.

Step 3. Open Spreadsheets and press in a cell to view the New Zealand date format.