>>>From Excel, a date field has been converted to a numeric value after the import.
>>>
>>>So, a date like 1/12/1999 could give a value like 35827. Some other fields gave something like 35957.50841435185. Is there a simple formula to reverse that to the date value?
>>
>>
>>I have found that if the date was formatted 01/12/1999 (this is two digit month & day) in Excel it imported correctly.
>
>I imported the file using the File Import option. I didn't use the Import Wizard. Maybe I should have used it. Could this be a factor?

I've found there are differences wieh using the two. When I imported the Excel files, I used APPEND FROM file TYPE XLS. When the dates were formatted as 1/2/1998, the dates did not import correctly. Changing them to 01/02/1998 fixed the problem.