How To Change Date Format To DDMMYYYY In Google Sheets

When working with dates in Google Sheets, it is important to have them displayed in a format that is easy for you to understand and work with.

One popular format for dates is DDMMYYYY, which displays the day, month, and year in numerical form.

In this article, we will show you step-by-step how to change the date format to DDMMYYYY in Google Sheets.

Step 1: Select The Cells With The Dates

The first step in changing the date format is to select the cells that contain the dates that you want to change.

You can select one or multiple cells by clicking and dragging over them, or by holding down the “Ctrl” key while clicking on individual cells.

Step 2: Right-click And Select “Format Cells”

Once you have selected the cells, right-click on any of them and select “Format Cells” from the context menu.

READ NEXT:   Unlocking the Power of Google Sheets: Tips and Tricks for Advanced Users

Step 3: Select “Date” And “Custom”

In the “Format Cells” window that appears, select the “Date” category on the left side, and then select “Custom” on the right side.

Step 4: Enter The DDMMYYYY Format

In the “Type” field, enter “DDMMYYYY” without the quotation marks.

This will change the format of the selected cells to display the day, month, and year in numerical form.

Step 5: Click “OK”

Click “OK” to apply the changes and close the “Format Cells” window.

The dates in the selected cells should now be displayed in the DDMMYYYY format.

Change Date Format to DDMMYYYY in Google Sheets

Please note that this article is focused on changing the date format to DDMMYYYY in Google Sheets.

READ NEXT:   Inserting Sheets in Google Sheets: The Ultimate Guide

The steps may vary slightly depending on the version of Google Sheets you are using.

By following the above steps, you can easily change the date format to DDMMYYYY in Google Sheets and make your date data much more readable and easier to work with.



In conclusion, changing the date format to DDMMYYYY in Google Sheets is a simple process that can be done in a few easy steps.

By selecting the cells, right-clicking, and selecting “Format Cells,” you can change the date format to DDMMYYYY and make your date data much more readable and easier to work with.

With this article you will be able to format your date in a way that is easy to read and understand, and make sure your data is organized in the way that works best for you.

READ NEXT:   How to List Sheet Names in Google Sheets

Similar Posts: