Peter,
The best thing I can recommend is to use Office Automation to create the spreadsheet. I would assume that if your having a problem formatting dates, you are going to have a problem with other formatting also. Using Automation will give you complete control over the formatting.
PF
>When I export a table containing a DATE field to a XL5 file in VFP 5.0, the date fields are always interpreted as text, not dates. I have tried fiddling with the SET DATE command, I have setup the date format in the Windows control panel and have tried with different language versions of Windows and Excel, all to no avail. Does anyone have any suggestion?
>
>Thanks!
(On an infant's shirt): Already smarter than Bush