I imported csv data, a date, as text. After importing in my spreadsheet, I tried to format the column to a particular date format but it does not seem to work. Any workaround to this?

During data importing, I suspect there cannot be different formats among the columns and is it all one way. I haven't tried but perhaps one could probably import the date separately from the other column data? The later option seems like lots of work to simply obtain a desired date format. Any suggestions welcomed.

I don't think this needs to be a separate thread as it's part of the same issue I posted.

Thanks,
Keith