| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do I change date from mm/dd/yyyy to dd:mm:yyyy format in Excel | New Users to Excel | |||
| Change in Link Behavior - Excel 2000 to 2003 | Links and Linking in Excel | |||
| Excel date format trouble | Excel Discussion (Misc queries) | |||
| How do I change a date format 3/14/2006 to 3-14-2006 in Excel 2002 | Excel Discussion (Misc queries) | |||
| Can I program Excel cells to change colour at a set date? | Excel Discussion (Misc queries) | |||
Linear Mode
