How can I change Excel to use the British date system?
 

My copy of Excel seems stuck in the default (US) date format which can get
very confusing. How can I change it to the British system which I'm used to?
i.e. dd/mm

How can I change Excel to use the British date system?
 

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

How can I change Excel to use the British date system?
 

"EddieA" wrote in message
...
My copy of Excel seems stuck in the default (US) date format which can get
very confusing. How can I change it to the British system which I'm used
to?
i.e. dd/mm

Problem may not be in Excel, but in Windows. Regional Settings?
--
David Biddulph

How can I change Excel to use the British date system?
 

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