Data coverts to dates (case 16111)
Data coverts to dates (case 16111)
Hi so my study tests ppts ability to memorize and later reproduce a list of numbers. For purposes I shall not elaborate, the list of 4-digit numbers in one condition are separated by a dash right in the middle (xx-xx). So I created xx-xx fill in the blanks for those numbers. where the dash (-) is already fixed and ppts just have to fill in the 4 digits. Which is all good. Until I realized that in the data sheet, rather than numerals, dates rather than numerals appear. If the ppt had answered with a 21-10, the data says 21 October, converting the two numbers behind the dash to a month. How do I get a round this prob? Btw, the dash has to be fixed beforehand so letting ppts type their own dash isnt an option. In case anyone is thinking of that.
Appreciate any inputs, thanks in advance!
In the MediaLab .que file, try checking the "Write as text" box for this item for any new participants you have yet to run.
For the data you already have, you just need to find a way to convert the data in the date form already in the sheet to a form you desire. Try starting with the advice here: http://en.kioskea.net/forum/affich-28689-changin-format-of-date-in-excel.
