CONVERTING DATE FORMARTED AS GENERAL IMPORTED FROM AN EXTERNAL SOURCE

[TALEE]

Hi.
I have a long report imported from an external source with dates formatted as General e.g. 20210709.
How do I convert these dates to dd/mm/yyyy please?

 

[JamesCanale]

Do it like this:

MrExcelPlayground6.xlsx
	B	C
19	20210709	7/9/2021
Sheet20

Cell Formulas
Range	Formula
C19	C19	=DATE(LEFT(B19,4),MID(B19,5,2),RIGHT(B19,2))

And then format the output in the right date setting for your region.

 

[TALEE]

Do it like this:

MrExcelPlayground6.xlsx
	B	C
19	20210709	7/9/2021
Sheet20

Cell Formulas
Range	Formula
C19	C19	=DATE(LEFT(B19,4),MID(B19,5,2),RIGHT(B19,2))

And then format the output in the right date setting for your region.

Thank you very much. This worked.