On Fri, 1 Jul 2005 22:34:34 -0500, 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

Format/Cells/Custom Type d/m

Note that Excel will automatically add the current year; which will appear in
the formula bar, but not in the cell with the above custom format.


--ron