>Hi all
>
>I have a typical problem. After exporting a date field from a VFP table, say Date of Birth, into Excel, the dates that can be represented as British and American (albeit wrongly if the other way round) format well in Excel but when a date that has a day which cannot be formatted in American will not be considered for any type of date formatting in Excel, for eg.
>
>07-04-1965 (7th April 1965) will format perfectly in Excel but
>23-06-1970 (23rd June 1970) whatever I do it won't format in Excel as a date. I have tried to change the Regional settings to either and yet the problem remains for such date.
>
>Please advise what might not be gelling.

Bhav,

Check this thread, please Re: Strange date formatting Thread #1346235 Message #1346277