recieving quizzing results ecxel

  • 1
  • Problem
  • Updated 7 years ago
Archived and Closed

This conversation is no longer open for comments or replies and is no longer visible to community members. The community moderator provided the following reason for archiving: Inactive threads; archiving to prevent necroposing

Hi,

i am recieving every quizzing result in a messy way on excel. I did every step is shown on the video tutorial. It doesn't show every data by colums it is showing everything in the same row like this

Last Name,"First Name","Email Address","Quiz Name","Question Number","Question Type","Question Text","Viewer Answer","Correct Answer","Answered Correctly","Percentage of Segment Viewed","Time to Complete","Video Start Time (GMT)","Quiz Finish Time (GMT)","Video Name","Camtasia Project Name","Video Duration" Claudia,"Rodriguez","crodriguez@oicolombia.com","SARLAFT","0","MC","La sigla SARLAFT significa","Sistema de Administración del Riesgo de Lavado de Activos y de la Financiación del Terrorismo","Sistema de Administración del Riesgo de Lavado de Activos y de la Financiación del Terrorismo","Yes","100.00%","00:21:50","4/16/2013 3:19:08 PM","4/16/2013 3:40:58 PM","SARLAFT","SARLAFT","00:11:49"

How can get the results organized like it is supposed to be?

thank you for your help.
Photo of Lorena Rodríguez

Lorena Rodríguez

  • 4 Posts
  • 0 Reply Likes
  • FRUSTRATED

Posted 7 years ago

  • 1
Photo of Logan S.

Logan S.

  • 2813 Posts
  • 153 Reply Likes
Hey Lorena,

Any chance that your computers language settings are set to something other than English?
Photo of Lorena Rodríguez

Lorena Rodríguez

  • 4 Posts
  • 0 Reply Likes
Hi Logan,

well Microsoft is in English but i guess that the computer settings are in spanish...
Photo of Logan S.

Logan S.

  • 2813 Posts
  • 153 Reply Likes
Hey Lorena,

That is the issue. With a foreign language, it sometimes interprets decimals as periods, and can't format it correctly. You can try setting it to english, and seeing if that takes care of it.
Photo of Lorena Rodríguez

Lorena Rodríguez

  • 4 Posts
  • 0 Reply Likes
Noooo... ok, i guess i have no option!

thank you for your help. I hope that would be it.

This conversation is no longer open for comments or replies.