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

  • Profile Image
    Asked on January 14, 2016 at 04: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?


  • Profile Image
    Answered 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:


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


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