I get a CSV data extract, and date format is dd/mm/yyyy. I import the data into an excel sheet, and this used to work well (on XP).
Now I use a VISTA machine, still with Exel 2007, and the format seems to revert to mm/dd/yyyy. I've changed the regional settings so that it shows dd/mm/yyyy, but it still doesn't work. Are there other places in VISTA where date format needs to be changed?