How to Change the Date Format in Excel

1. Start by opening the Excel workbook where you want to change the date format.

2. Click and drag to select the cells containing the dates you want to format.

3. Navigate to the ‘Home’ tab in the Excel ribbon at the top.

4. In the ‘Number’ group, click the small arrow next to ‘Number Format’ to open the ‘Format Cells’ dialog.

5. In the ‘Format Cells’ dialog, select ‘Date’ from the list of categories on the left.

6. In the right panel, choose your preferred date format from the list of available options.

7. Finally, click ‘OK’ to apply the changes and update the date format in your selected cells.

8. Enjoyed the guided demo?

This interactive demo/guided walkthrough on How to Change the Date Format in Excel was created using Supademo.

How to Change the Date Format in Excel : Step-by-Step Guide

Begin by launching the Excel workbook where you have date values that need adjusting. Opening the right file ensures you're working in the correct place to update the date formats smoothly.

Next, highlight the cells containing the dates you want to modify. You can do this by clicking and dragging your cursor over the relevant ranges—this helps Excel know exactly which data you're targeting.

Now, look towards the top of your Excel window and select the ‘Home’ tab on the ribbon. This tab contains the controls you'll need to change how your data is displayed.

Within the ‘Home’ tab, locate the ‘Number’ group. Here, click the small downward arrow next to the ‘Number Format’ box to open up the ‘Format Cells’ dialog box. This panel allows for detailed formatting options.

Once the ‘Format Cells’ window appears, find and click on ‘Date’ in the list of categories on the left side. Selecting this category filters the options specifically for date formats.

On the right-hand panel of the same dialog, browse through the available date format options. Choose the style that best fits your needs, whether it’s a standard format or something customized.

When you’ve decided on a date format, click the ‘OK’ button to confirm your selection. This action updates the format of the selected cells, instantly reflecting the new date appearance.

That’s it! If you found this step-by-step guide helpful, feel free to explore more features or revisit any step to refine your formatting as needed.

Create your own interactive demos in < 5 mins with Supademo

You can create your own interactive product demo in minutes using Supademo. Drive growth, scale enablement, and supercharge product-led onboarding with Supademo. Sign up for free here with no credit card required.