User can reformat cells in Excel. But it is not simple enough and definitely is not convenient. I would set century on and provide user with additional column having dates converted as dtoS(..).

Hope this help.


>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