CSV Export - Date formatting
I have been exporting my deals to a CSV file into excel. The only issue I am having is that if the date is a doube digit (25, 16, 11 etc) then the cell is not picked up as a date. If the date is a single digit (1, 5,7 etc) there doesnt seem to be an issue. Anyone have the same issue and knows how to resolve this without having to esnure every date field is a single character?