I am facing problem when importing data from Excel 97 & operating system windows 98.
In the Excel sheet coloumn b is a date coloumn. ( all the values are date value no header row)
Foramt of this cell is Custom MM/DD/YYYY. I also tried various Types in Date format Categeory.
I am using Import and Append Command. Import column converts the values in to numeric data type.
while using Append command date field is left blank.
I also tried import Wizard but faced same problem.

I have also tried changing windows regional settings.

There is no problem if use same commands in excel 2k.

Please Help