Ideas to convert Text to a date

[Zandor435]

Data comes out of my database formatted as follows with just the year and month.

201804 for April, 2018 or 201805 for May, 2018.

Also, the date is a number stored as text.

I am trying to group that date in a pivot table but unable to without quite a bit of manipulation.

Currently I am using text to columns and the joining the data back but this takes quite a few steps.

Can anyone suggest a faster or more efficient way to accomplish what I’m trying to do?

 

[Dave Patton]

If possible, edit the import to show true date.

Excel 2010
	B	C
1	201804	1-Apr-18
2	201805	1-May-18
3
4c

Cell Formulas
Range	Formula
C1	=DATE(LEFT(B1,4),RIGHT(B1,2),1)

 

[Rick Rothstein]

Put this formula in a cell and format the cell with the date display format you want...

=0+TEXT(A1,"0000-00-\01")