K
keitija
Version: 2004
Operating System: Mac OS X 10.4 (Tiger)
Processor: intel
Hi!
I am trying to sort a list by date. I have entered the dates in European/UK format i.e. dd.mm.yy. However, when I sort, it sorts by US format - mm.dd.yy. I have tried everything to make it sort by the UK format, but no luck. I have checked the International system preferences and date format is set to UK. I have restarted Excel. I have tried setting the cells to date format, but the only options there are variations on the US format.
Any ideas?
Operating System: Mac OS X 10.4 (Tiger)
Processor: intel
Hi!
I am trying to sort a list by date. I have entered the dates in European/UK format i.e. dd.mm.yy. However, when I sort, it sorts by US format - mm.dd.yy. I have tried everything to make it sort by the UK format, but no luck. I have checked the International system preferences and date format is set to UK. I have restarted Excel. I have tried setting the cells to date format, but the only options there are variations on the US format.
Any ideas?