wrong data format in google sheets

  • Profile Image
    BuryTrainingServices
    Asked on October 26, 2020 at 08:53 AM

    hi Guys

    have looked through forum for answer but unable to find

    i have the incorrect date form showing on google sheet on some entries

    example

    a form with the date entered of
    3rd September 2020

    shows as
    09-03-2020
    on google sheet
    i understand how to change date format in sheets but if its taking incorrect info to start with
    im unable to correct using the date formatting method.


    the other issue is i have a entry on form for the trainee ratio which could be on most occasions be 1.1.1 however this then gets interpreted as a date when in google sheets.


    regards

    colin

  • Profile Image
    Sonnyfer
    Answered on October 26, 2020 at 09:45 AM

    Hi - This seems to be a duplicate ticket. Kindly refer to my reply on the following ticket link instead and reply there if needed to avoid confusion. https://www.jotform.com/answers/2655436

  • Profile Image
    Sonnyfer
    Answered on October 26, 2020 at 09:46 AM

    Sorry, looks like I overlooked the other issue you mentioned on this ticket. Let me address it on a separate ticket. Kindly wait for my response here.