hi!

change your regional settings in the control panel to UK!

-via135



Liesl Wrote:
Hi there,

I'm trying to change the format so that when I type in 1/3 it comes up
with
01 Mar, rather than 03 Jan? I also want to make it stay that way so
that when
I open it the next time, it will do the same. Can anyone help me?


--
via135
------------------------------------------------------------------------
via135's Profile: http://www.excelforum.com/member.php...o&userid=26725
View this thread: http://www.excelforum.com/showthread...hreadid=526973