Date change/format issue

[jacques1]

Dear All, it seems like a systems problem. On my pc if i enter the date in any blank sel starting with the ddmmyy the display date will automatic be inverted to yymmdd. This happen irrespective the date format you choose. How can one set it to accept the entry ddmmyy and keep it that way to function as a date.

 

[Andrew Poulsom]

If you enter 17/08/07 in a cell how does it appear? And what number do you get if you format the cell as General?

 

[Peter_SSs]

jacques1

Have you checked your settings in Control Panel|Regional and Language Options|Regional Options...|select language then|Customize|Date tab?