Changing YYYYMMDD to MM/DD/YYYY
So I have a date that is 20170529 but whenever I try to format it to a date, the cell just becomes #########. So normally, that means the column width is too small, but even when I extend the column, it just shows #####
How do I convert these to dates.
=DATEVALUE(TEXT(A1,"0000\/00\/00"))
and format the result as a date
A quick method would be Data, Text-to-Columns, Fixed Width, Date: YMD, Finish. The following is for all intents and purposes in real-time.
Shouldn't take too much to record that into a sub procedure.