Date formatting

[2CL-Excel]

Hi

I need a formula that turns this value 20060323 (YYYMMDD) into a short date - 23/03/2006 (DD/MM/YYY)

I have had a google and a look on this messageboard but I haven't had much luck. 

Thank you

[#2]

@2CL-Excel 

With a number such as 20060323 in A1:

=DATE(QUOTIENT(A1, 10000), MOD(QUOTIENT(A1, 100), 100), MOD(A1, 100))

Apply the desired date format to the cell with the formula.

[#3 · Accepted solution]

@2CL-Excel You may try-

=DATEVALUE(TEXT(A1,"0000\/00\/00"))

[#4]

Thank you!