View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Manoj
 
Posts: n/a
Default 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?