I have a worksheet with a column with date and time that I get from our IT showing all incoming and outgoing calls. The date and time column is formated to show Aug 30, 2019 7:15:22PM. I want to change the format to be mm/dd/yy hh:mm. When i highlight the column and go to custom and format the way I want and then hit enter, nothing happens until i click into each individual cell. Then it changes to the custom format. How can I get it to change to the new format without having to click in and out of each cell.