Date issues when downloading bank statement

[kshines]

Wise people of the forum,
I am having issues when downloading my bank statement in the way it randomly sets the format for the dates. It appears to be no rhyme or reason. I am looking for a way to get it formatted back to a date allowing me to extract month / year instead of the - or /. Thanks in advance!
KH
Below is a sample.

12/14/16
12/14/16
12/13/16
12/13/16
12-12-16
12-12-16
12-12-16
12-12-16
12-12-16
12-12-16

<tbody>
</tbody>

 

[Max1616]

Assuming your data starts in cells A1 you can use this formula:
=TEXT(A1,"MM/DD/YYYY")

It will convert everything to the same format.

Sincerely,
Max

 

[Tetra201]

Try the following:

- Select the column with the dates
- Go to Data --> Text to Columns
- On Step 3 of 3, select 'Date: MDY'
- Click 'Finish'

 

[Guru008]

Hi,

Select the column containing Date, Press Ctrl+1 , click on date and format the cell according