Date Wrong In Excel

[DavCl]

Could anyone please help
I have built a form that inputs information into Excel one of the fields is a date format "d/m/yy"
When it inputs this into Excel it imports the date as "m/d/yy"
Any help appreciated

 

[SkipVought]

Hi,

faq68-5827

The take away is that Excel assumes that your date is m/d, so ENTER it that way in the sheet.

FORMAT your date cells to DISPLAY d/m.

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]