Dates format

[alliswell]

Hi everybody. Good morning. It's raining here.

I put 03122023 in a1 and want it to get converted as date in b1 or a1 itself as 03/12/2023

Thanks and regards

 

[Herakles]

=DATE(RIGHT(A1,4),MID(A1,3,2),LEFT(A1,2))

 

[MARK858]

Another option... I can't tell what region you are in but the below is for my region, B1 is formatted as dd/mm/yyyy as I can't tell by your post whether 03 or 12 is the day or the month and my regional format is dd/mm/yyyy

Book1.xlsb
	A	B
1	03122023	03/12/2023
Sheet1

Cell Formulas
Range	Formula
B1	B1	=TEXT(A1,"00-00-0000")+0