Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-03-2019, 09:17 AM
oliboi oliboi is offline Excel converting answers to dates from Google Forms Windows 10 Excel converting answers to dates from Google Forms Office 2016
Novice
Excel converting answers to dates from Google Forms
 
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
  #2  
Old 12-03-2019, 03:59 PM
p45cal's Avatar
p45cal p45cal is online now Excel converting answers to dates from Google Forms Windows 10 Excel converting answers to dates from Google Forms Office 2019
Expert
 
Join Date: Apr 2014
Posts: 863
p45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant future
Default

Could you attach such a CSV file here?
Reply With Quote
  #3  
Old 12-04-2019, 04:21 AM
ArviLaanemets ArviLaanemets is offline Excel converting answers to dates from Google Forms Windows 8 Excel converting answers to dates from Google Forms Office 2016
Expert
 
Join Date: May 2017
Posts: 869
ArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud of
Default

Open Excel (no file is open). Select Open File dialog, set file type to any type, and open your csv-file. When allowed to determine column formats, set format for answers column to text.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel converting answers to dates from Google Forms Dates, Forms, Calculations etc. ElfegoBaca Word VBA 2 09-17-2019 04:23 PM
vba google search on chrome from excel mbasith Excel Programming 5 10-26-2018 06:37 AM
Excel converting answers to dates from Google Forms Error in exporting Google Sheet to Excel cmcmeekin Excel 2 08-03-2016 11:32 AM
Excel converting answers to dates from Google Forms Excel 2010 - Converting fractions into dates judicial85 Excel 5 12-31-2011 07:59 AM
Using Spreadsheet to integrate Google forms and MS Word swedy13 Excel 0 07-13-2010 06:06 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:41 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft