Hello Ladies and Gentlemen,
I have a column of dates, that I want in UK date format (DD/MM/YYYY)
Occasionally, the data I receive the dates are muddled up, some are in DD/M/YYYY and some are in MM/DD/YYYY
The ones with a star are incorrect, and come in 'General' format.
<colgroup><col></colgroup><tbody>
</tbody>I CAN already convert these, by selecting MDY in the 'Text To Columns' Wizard.
However, occasionally, my columns are dates that ARE already in the correct format. So if I run the wizard, it converts some from DD/MM/YYYY to MM/DD/YYYY.
Would there be some wizardy, where it looks at a column, and if the dates are all already in DD/MM/YYYY, don't do anything, but if there are some in MM/DD/YYYY, then convert these to DD/MM/YYYY?
Thank you.
I have a column of dates, that I want in UK date format (DD/MM/YYYY)
Occasionally, the data I receive the dates are muddled up, some are in DD/M/YYYY and some are in MM/DD/YYYY
The ones with a star are incorrect, and come in 'General' format.
Date |
03/06/2017 |
07/18/2017* |
03/16/2018* |
02/26/2018* |
03/10/2018 |
04/11/2018 |
05/13/2017* |
<colgroup><col></colgroup><tbody>
</tbody>
However, occasionally, my columns are dates that ARE already in the correct format. So if I run the wizard, it converts some from DD/MM/YYYY to MM/DD/YYYY.
Would there be some wizardy, where it looks at a column, and if the dates are all already in DD/MM/YYYY, don't do anything, but if there are some in MM/DD/YYYY, then convert these to DD/MM/YYYY?
Thank you.