However, if you enter your 170983 into cell A1 with the following
formula in B1
=DATE(RIGHT(A1,2),MID(A1,3,2),LEFT(A1,2))
.... and format it for dd/mm/yyyy format Excel will convert it to a
serial date.