ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Problems with date input (https://www.excelbanter.com/excel-discussion-misc-queries/85153-problems-date-input.html)

timbloke

Problems with date input
 
I've searched through the questions, but cannot find a logical explanation.
I've recently upgraded to Excel 2003, but for whatever reason it is usin
mm/dd/yyyy format as the default, rather than dd/mm/yyyy. I have checked,
double checked and checked again my regional settings which are EN (UK) and
have dd/mm/yyyy as the default, but it still won't change in Excel.

Anyone got any suggestions why?

Manoj

Problems with date input
 
Try changing the format in Excel - it might be in mm/dd/yy format.

"timbloke" wrote:

I've searched through the questions, but cannot find a logical explanation.
I've recently upgraded to Excel 2003, but for whatever reason it is usin
mm/dd/yyyy format as the default, rather than dd/mm/yyyy. I have checked,
double checked and checked again my regional settings which are EN (UK) and
have dd/mm/yyyy as the default, but it still won't change in Excel.

Anyone got any suggestions why?



All times are GMT +1. The time now is 08:20 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com