Dear all,

Office 2003, Windows XP Pro SP3

I have a column of dates in the following form 13.11.2009 (i.e. dd/mm/yyyy)
where the cells' format are 'General'. I wanted to sort in ascending date
order from 01/01/2009 to 31/12/2009. I tried formatting the cells to date and
use the sort but what that did was to sort in this manner: 01.01.2009,
01.02.2009 - - - 01.12.2009 then 02.01.2009, 02.02.2009 i.e. by months first
then by dates. Even when I have chosen dd/mm/yyyy formatting, not only the
content won't change the sort still perform as I have just described. I have
also tried the formula =DATEVALUE(DAY(A1) & "/" & MONTH(1) & "/" & YEAR(A1))
without success (it returns VALUE! error in the adjacent column)

I would appreciate therefore if someone could advice me how to change the
dd.mm.yyyy (for which the cells are formatted 'General') in a new column to
dd/mm/yyyy.

Thank you,
jes