Change submission date to dd/mm/yyyy format

  • Profile Image
    Asked on September 12, 2014 at 09:06 AM

    submission date format changes suddenly with no reason. please see screenshot


    i need them to be date, month, year in order to sort them Z-A in google sheets


    now its in the format: month, date, year


    it is confusing

  • Profile Image
    Answered on September 12, 2014 at 10:50 AM

    You can format the date in your spreadsheet settings. Please see the image below:

    You can change your spreadsheet date to dd/mm/yyyy and once you revisit your spreadsheet link the format will be like that.