06-12-2019 11:03 AM
06-12-2019 11:21 AM - edited 06-12-2019 11:22 AM
You can use this formula below to convert it into a proper date:
After that you can press Ctrl+1 to open the Format Cells dialog box, then go to Custom and use this custom format (yyyy/mm/dd), then hit OK.
Hope that helps
by ThomasBraasETH on May 07, 2020