you could try a custom format. click cells/format, select custom and enter
d/m/yy (or d/m/yyyy for 4 digit year).



"andrewm" wrote:


Hi,

I would like to put a date in a cell eg 1st march 2005 as 1/3
however it comes up with 3/1 (the month first)
how can I change it.
in control panel I have settings english(australian)

thanks

andrewm


--
andrewm
------------------------------------------------------------------------
andrewm's Profile: http://www.excelforum.com/member.php...o&userid=23130
View this thread: http://www.excelforum.com/showthread...hreadid=384045