Dating Backwards

A developer wrote a convoluted Excel formula (in French locale) to convert dates from DD/MM/YYYY to YYMMDD format by manually padding numbers using multiplication. Instead of using Excel's built-in date formatting, the formula multiplies year/month/day components by 10 when they're single digits — a flawed approach that produces incorrect results like turning February 1st, 2009 into '90210'. The correct solution would be to use Excel's native formatting functions, or at minimum treat the date as text and concatenate substrings.