Thanks but what can i do in excel. the data ARE already there. And the dates look like "24-Mar-00"
Id there a At function alike in excel so I could somthing like =date((mid(f2,1,2),AT(mid(f2,4,3),"JanFebMar...")/3......
to convert into a data for sorting???
Peter
>>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
Peter Cortiel