Hi EddieA,

If you select English (UK) in Windows/Regional settings, Excel will follow
it as default.

Regards,
Stefi


€žVBA Noob€� ezt Ã*rta:


Hi,

Select format cells Date location then select English (UK)

Also can do custom and enter the format you want

http://www.ozgrid.com/Excel/CustomFormats.htm

VBA Noob


--
VBA Noob
------------------------------------------------------------------------
VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833
View this thread: http://www.excelforum.com/showthread...hreadid=564655