How to change date format in excel to dd/mm/yyyy

You want day before month when entering date in excel ?

Well, you can swap or reverse day and month of date in Excel

If you want to change date format in excel to dd/mm/yyyy, please do as follows :

  1. Select the date cells you will swap the days and months, and then press the Ctrl + 1 keys to open the Format Cells dialog box.

  2. In the Format Cells dialog box, please click Custom in the Category box under Number tab. If the original date formatting is m/d/yyyy, please enter d/m/yyyy into the Type box, and if the original date formatting is d/m/yyyy, please enter m/d/yyyy into the Type box, and finally click the OK button. See screenshot:

Now the day and month are swapped in selected date cells.

source : How to swap or reverse day and month of date in Excel?

Disclaimer : Every member of NetDivo forum is solely responsible for anything that he/she posts or uploads on this forum.
web stats