dd/mm/yy to mm/dd/yy

  • Thread starter Thread starter joao
  • Start date Start date
If you right click the mouse on the cell and choose Format cells, go t
the number tab and click on Custom in the Type box enter your forma
dd/mm/yy.

You can use this method to change the format to any other date forma
that does not appear in the standard date list
i.e. dd mmm yyyy would give 11 Nov 2003
and ddd dd mmmm yyyy would give Tue 11 November 2003

Hope this helps

Mik
 
Select the cells and use Format/Cells/Number/Custom and enter as you
wish or select from list provided

DavidP
 
Back
Top