I am trying to process a large amount of data that has the format dd/mm/yyyy
hh:mm:ss and needs to be converted into yyyy/mm/dd hh:mm:ss. I have
successfully created a custom cell format for the date, but the cells will
only change when I double click on them, which is not practicable for the
amount of data I have. Format painting does not automatically change the
cells. Paste special does not work and I have also tried saving & closing
the worksheet, to no avail. Anyone got any clues?