Convert Date Format to dd/mm/yyyy in Excel

February 2018

Microsoft Excel is a software that allows you to create efficient spreadsheets for business of personal use. They permit you to stay organized while managing large amounts of data, which can be organized in a range of ways.

One popular way to organize this data is by date. Excel comes with a default date format, mm/dd/yyy, but you can always choose to change the date format, to dd/mm/yyy, for example.

Change Excel Date Format from mm/dd/yyyy to dd/mm/yyyy

To change the date display in Excel, go to Format Cells > Custom, and enter dd/mm/yyyy in the available space.

The dates listed in your spreadsheet should be converted to the new format.


Image: © Microsoft.
Published by owilson. Latest update on February 18, 2018 at 11:40 AM by owilson.
This document, titled "Convert Date Format to dd/mm/yyyy in Excel," is available under the Creative Commons license. Any copy, reuse, or modification of the content should be sufficiently credited to CCM (http://ccm.net/).
How To Copy Data from One Excel Sheet to Another Using a Formula
Adding a VBA CommandButton with its respective the code