I have columns of various types which need different formats. I'm aware Excel treats dates as a number, but I have a column which has dates as custom type in the format "M/D/YYYY H:MM". If I find a cell like this I need to keep the date. I've used a case statement for the other formatting & it...