Date and Time Values are Shown Like Text on Google Spreadsheet Document

  • glidetalk
    Asked on January 14, 2016 at 4:30 AM

    I have a form that includes the standard date/time picker with the format set to ddmmyyyy.

    when passing it to google sheets (into a date formatted column) the value appears with a ' in front of the date so it's treated as text rather than a date.

    Any idea why?

     

  • mert JotForm UI Developer
    Replied on January 14, 2016 at 10:53 AM

    Hi there,

    I tried the clone of your form on "Google Spreadsheet" and didn't find anything like " ' " in front of the "DateTime" field value. Please, see it from the below:

    Date and Time Values are Shown Like Text on Google Spreadsheet Document Image 1 Screenshot 20

     

    Also, you can re-format the column by using the following guide:

    https://support.google.com/docs/answer/56470?hl=en

     

    If you refer something else or need more information, please let us know.

    Thanks.