You are reading a single comment by @pifko and its replies. Click here to read the full conversation.
  • 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)

About

Avatar for pifko @pifko started