top of page

Change Date Format in Excel

  • Writer: Harshal Srivastava
    Harshal Srivastava
  • Apr 7, 2021
  • 1 min read

Open your workbook consisting of the date.


2. Select all the cells consisting of Date by pressing "Ctrl" and left click.


3. Right-click and choose "Format Cells".


4. Then from the location dropdown, choose the UK for setting the date in DD/MM/YYYY format.

5. Hit "OK" and your format has now been changed from "MM/DD/YYYY" to "DD/MM/YYYY".


6. Just above location you can also select the type of date you want to display.



Comments


©2021 by Tech Aficionado.

  • 0c23332059f19519c291c00496b5f056
  • Facebook
  • Twitter
  • LinkedIn
bottom of page