Weird Date Format 20160726

[jeffmoseler]

I have a spreadsheet that is sent to me with a strange date format that I would like to convert to a more standard format. It looks like this when I get it:

20160726

Which translates to 07/26/2016.

There are about 58,000 rows with this weird date. What do you think would be the fastest way to convert this date format to a standard 7/26/2016 format? Do I have VBA run a loop for each cell? Do I add a column and enter a formula and copy the formula down and then paste the data only to another column?

Let me know what you think!

 

[Fluff]

Select the column with the dates > Data tab > Text to columns > delimited > next > clear all check boxes > Next > Select YMD > OK

 

[jmacleary]

Fluff's answer is correct. Just to point out to you that the date format yyyymmdd is not really 'weird' and was in very common use in the past, as it enabled sorting into date order (excel nowadays is more aware of dates). I still use this format when naming files in a folder, etc.