MrExcel.com - Your One Stop for Excel Tips & Solutions

DD/MM/YY

Posted by RogerBlack on September 18, 2001 7:48 AM

hi there,
i have written my code for the date to be entered in dd/mm/yy format but when i update my form 28/01/01 is 01/01/28 i have tried almost everything i can think of to change this without any results. can anyone help me with the problem i have to create about 8 more forms and this is really driving me crazy.

Cheers

Posted by Andrew Cheung on September 18, 2001 7:58 AM

Hi,
I think it is the global setting in your computer.
You can change this global setting in Control Panel > Regional Setting > Date to change the date format to "dd/mm/yyyy"