View Single Post
 
Old 12-03-2019, 09:17 AM
oliboi oliboi is offline Windows 10 Office 2016
Novice
 
Join Date: Feb 2016
Location: Canada
Posts: 20
oliboi is on a distinguished road
Default Excel converting answers to dates from Google Forms

I have downloaded a CSV file from Google Forms which contains data from respondents. But when I open the file, I realize Excel is converting some of the data to dates. For example, if someone indicated "5-6" as a multiple choice answer, then Excel is reading it as 5-June (6 being the month and 5 being the day).

I have tried to go back and change the multiple choice answers to "5/6" on the form itself, thinking the "-" is the issue, but it seems it is still not working. Also, this won't be possible if it is a comment box and respondents themselves write answers like "5-6", "6-8", etc.

When I change the format of those cells to text, I get random numbers like 43500.
Reply With Quote