If you only need to see 20 100 10 1, you only need to set the cell format-custom format and set it to YYYYMMDD.

If you want to convert the date into such a string, you should use the formula (2010-1-kloc-0/in column A):

= = Year (A2)&; IF(LEN(MONTH(A2))= 1, "0" & month (A2), month (A2))&; IF(LEN(DAY(A2))= 1, "0"&day (A2), day (A2))