thank you for reply,and help
i mean somthing via yourcode to be clear for me if you don't mind.

>>thank you very much, it works.
>>i need your help agin to copy it at one excel book (sheet1,to .....sheet18) to ("c:\dept\amman)
>>
>
>Check Cetin's Vfp2Excel function <B>Re: Exported date to Excel won't format as date</B> Message #1399567