dd/mm/yy to mm/dd/yy

[joao]

hi

is there any way to format all dates as dd/mm/yy

 

[Freemini]

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

 

[DavidP]

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

DavidP