You are reading a single comment by @ChainBreaker and its replies. Click here to read the full conversation.
  • yeah, half of them are text.

    Multiply by 1 to make them numbers, then format as a date

    =A1*1

  • Any chance you could upload it here. I want to see if I can copy and paste it over.

    =a1*1 didn't work for me on column D

About