Change submission date to dd/mm/yyyy format

  • Profile Image
    stevenyilin
    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
    jedcadorna
    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.