Another case of crap source data here. I have a range of dates formatted like this: 1201
How can I convert these into 01/12 or possibly 01/12/2017?
Is there something a little more elegant than the below?
=RIGHT(A1, 2)&"/"&LEFT(A1, 2)&"/"&B1
(B1 being the year)
@pifko 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.
Another case of crap source data here.
I have a range of dates formatted like this:
1201
How can I convert these into 01/12 or possibly 01/12/2017?
Is there something a little more elegant than the below?
(B1 being the year)