On Sun, 30 Sep 2012 12:50:54 +0100, stuart noble wrote:

On 30/09/2012 10:23, PeterC wrote:
On Sat, 29 Sep 2012 10:19:49 +0100, stuart noble wrote:

Thanks for the suggestions - I'll try them v. soon (nearly the end of the
month).
The Date column sorts OK, as do all of the others with the exception of
Total; not only isn't it in the correct order for the new Date order but
it's not in anything logical at all.
If only I could predict the transactions I could keep the paper record to
match the xls file!


I just downloaded a Santander file in the xls format, and see that
things have improved since I last looked. Their date format is fine and
sorting all columns (B:H) by date was no problem.
Not sure what the "total" column is that you refer to.

Sorry, Balance (been doing gas, water and electric spreadsheets and, of
course, use Total in those.


In that case I'm stumped because it all works fine at this end. Are you
sure there's nothing lurking in column H, a formula of some kind maybe?
Try copying from the website and pasting into a new ss.

Thanks. The last column is just as currency - no formula - and copying and
pasting makes no difference.
The result is always the same in Excel 2003 and LibreOffice Calc, although
Calc offers the extended sorting.
--
Peter.
The gods will stay away
whilst religions hold sway