=DATE(B1,RIGHT(A1,2),LEFT(A1,2))
This'll store the result as a date, rather than a text string, so you can then date-format it however you like.
@Drakien started
London Fixed Gear and Single-Speed is a community of predominantly fixed gear and single-speed cyclists in and around London, UK.
This site is supported almost exclusively by donations. Please consider donating a small amount regularly.
This'll store the result as a date, rather than a text string, so you can then date-format it however you like.