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