I assume you mean by some other means than simply having them type "2/3", yes?
I assume you mean by some other means than simply having them type "2/3", yes?
Actually, I want subjects to be able to enter fractions, such as 2/3.
However, if I enter fractions, the data set converts these into dates, such as 3-Feb.
Efren
Excel does this or SPSS?
Excel does this. Is there a way to prevent this and have Excel capture the data in the right way (i.e., 2/3, etc.)?
Efren
Would you mind posting a sample Excel data file that shows this?
Here is the sample data set. The problem is with the variable named "veto". Notice that the value under that column is 3-Feb, when it should be 2/3.
That's strange. May I see the que file that produced this data file?