How To Change Date Format In Google Sheets To Dd/Mm/Yyyy

Google Sheets, a flexible and powerful online spreadsheet program, allows you to toggle between various date formats. However, it may not be immediately apparent how to change the date format to a particular style. In this blog post, we are going to explore how to adjust the date format to ‘dd/mm/yyyy’.

Steps to Change Date Format in Google Sheets

Here are the steps to change the date format in Google Sheets:

  1. Select the cells that contain the dates you want to change. You can do this by clicking and dragging your cursor over the desired cells.
  2. Click on the Format tab located on the top menu bar.
  3. From the drop-down menu, select Number, then More Formats.
  4. Now, select More date and time formats.
  5. In the opened window, customize your date format by selecting the ‘day’, ‘month’, and ‘year’ in the order that you want.
  6. Make sure to choose the format as dd/mm/yyyy.
  7. Click on Apply.

Your dates will be instantly transformed into the ‘dd/mm/yyyy’ format!

Using Google Sheets Functions to Change Date Format

Alternatively, Google Sheets has an in-built function, TEXT, for changing the date format.

The syntax of the TEXT function is: =TEXT(value, format_text). Here, ‘value’ is the cell that contains the date you want to change, and ‘format_text’ is the new date format.

To change the date format to ‘dd/mm/yyyy’, use the following formula:

=TEXT(A1, "dd/mm/yyyy")

Replace A1 with the cell that contains the date. When you press Enter, it will return the date in ‘dd/mm/yyyy’ format.


Changing date formats in Google Sheets is straightforward once you know where to look. Whether you prefer using the built-in menus or utilising Google Sheets’ powerful functions, you can easily change your dates to the ‘dd/mm/yyyy’ format. Remember, using the correct date format can make data management and analysis much easier.