>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.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer