Reply to thread

Message: [QUOTE="Ron Rosenfeld, post: 6453766"] Conceptually, I think if you want to be absolutely sure that your users will enter dates in a DMY format, you will have to have them enter the date and month and year separately. There is no way that Excel can tell, for example, if the user enters 9/3/10 if he means 3 Sep 2010 or 9 Mar 2010. The entry is ambiguous and Excel will interpret it according to the Windows Regional Settings. An alternative to requiring separate entry of day, month, year would be to display the interpreted date for user evaluation prior to storing it. In my opinion, this would be less "bullet-proof". [/QUOTE]