Date format

[annadinesh]

Dear Experts

My office software downloads data to excel in following date format
20220519

Please suggest me so that i can change the above date to 19.05.2022


Regards

 

[Dave Patton]

Dates and Time 2024.xlsm
	B	C	D
1
2	20220519	19-05-22	19-05-22
3	20241202	2-Dec-24	2-Dec-24
4
6a

Cell Formulas
Range	Formula
C2:C3	C2	=--TEXT(LEFT(B2,8),"0000-00-00")
D2:D3	D2	=DATE(LEFT(B2,4),MID(B2,5,2),RIGHT(B2,2))

 

[Peter_SSs]

.. or possibly just this?

24 12 03.xlsm
	B	C
1
2	20220519	19.05.2022
3	20241202	02.12.2024
Date

Cell Formulas
Range	Formula
C2:C3	C2	=--TEXT(B2,"0000-00-00")