date format
Posted by Alan on August 20, 2001 5:29 AM
I seem to have a problem with a user form I have developed.
The form is used as a purchase order interface and has a textbox in which the user inputs a date.
As I am in the UK. I need the date in the following format: dd-mm-yy .
I have formatted the destination cells in the worksheet, but regardless of this when I enter a date in the textbox, it is transferred to the destination form in American date format,; i.e. m-d-yy.
The only way I have been able to sort this out is to use letters for the month, something I am strongly trying to avoid.
I have set the UK. As the regional default in control panel, but still cant get it to play cricket instead of baseball!
Any ideas?
Thanks