Hello,

Right, im having a rather annoying little issue with excel at the min. I
have some data that has been imported into Excel. Basically, the date format
is YYYY/MM/DD hh:mm:ss. Now i want this to be displayed the English version
i.e. DD/MM/YY hh:mm yet when i highlight the cells and change the format of
them, nothing happens!! I have to go into each cell individually and double
click them for the date format to change....is there any way i can force this
change without having to click on each cell???

Thanks in advanced.