convert to date

[daveyc18]

so when i download data from a query,

the data column is 20201031 (ie 2020, october, 31). is there a way to convert this to a date format? i swear i remembeing doing it successfully once without having to use a formula...

 

[Fluff]

You can do it with Text to columns & select YMD for the date style on page 3 of the wizard

 

[Dave Patton]

Use
Data TextToColumns Date YMD
N.B. I put dates in B4; you could use A4.
Format your dates to your preference.

or use the Formula

T202011a.xlsm
	A	B	C
4	19200525	25-May-1920	25-May-1920
5	19600317	17-Mar-1960	17-Mar-1960
6	20201031	31-Oct-2020	31-Oct-2020
7	20200331	31-Mar-2020	31-Mar-2020
3b

Cell Formulas
Range	Formula
C4:C7	C4	=--TEXT(A4,"0000-00-00")