I have imported the list into an open office spreadsheet and all is fine except that I cannot
get the spreadsheet to sort in any sensible order using the 'last activity date' column.
The date is in the format mm/dd/yyyy so it sorts by month when I want year/month.
I can't seem to change the format of the date using the spreadsheet controls, I tried to change the
format of the date field when opening the file but this had no effect.
Can anyone help?
I know the 'last activity date' field is not entirely useful as it records last activity logged
which could be a change of address, payment rather than MP earned but I'm hoping it will be
a starting point to see which U members have stopped playing
![:)](http://www.bridgebase.com/forums/public/style_emoticons/default/smile.gif)