General information
Category:
COM/DCOM and OLE Automation
>When I do a copy to mySpredsheet type XLS in FP2.5 dates come into Excel as character
>When a user sorts on a date he gets all januaries all februaries etc.
>
>How can that be done right so the user can actually sort on a date column???
>
>Thanks
>
>Peter
When you do COPY TO, make it TYPE XL5. That gives you a more advanced format. (XLS is Excel 2; XL5 is, naturally, Excel 5.)
Tamar
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only