WPS Office

Free All-in-One Office Suite with PDF Editor

correct-icon

Edit Word, Excel, and PPT for FREE.

correct-icon

Read, edit, and convert PDFs with the powerful PDF toolkit.

correct-icon

Microsoft-like interface, easy to use.

Free download

Windows • MacOS • Linux • iOS • Android

banner

How to change date format in a cell

November 5, 2021
16.4K Views

We can present dates in different formats in the Format Cells settings. Follow these few steps.

1. Select the cell range filled with date information for format changes.

2. Right-click the cell range choose Format Cells from the pop-up menu.

3. Get into the Date tab choose a date format in the category of Type.

4. Click OK to complete the settings.

· More details about the interface for date formats

[Range A] Sample

Have a review of the date here.

[Range B] Type

A list of options for date formats is presented here. Choose one of them in your preference.

[Range C] Regional settings

Since the date format in different countries and regions might stay distinctive from each other, you can change the Regional settings for more date formats.

To be office excel advanced, you could learn how to use WPS Office Spreadsheet online in WPS Academy.

15 years of office industry experience, tech lover and copywriter. Follow me for product reviews, comparisons, and recommendations for new apps and software.