melendezml
Board Regular
- Joined
- May 5, 2014
- Messages
- 63
I downloaded a csv file of some student data.
The data below displays the number of students in a class.
For example, the first row displays 20 students out of 28.
Excel automatically converts some of the values to date such as 28-Jan (should be 1/28)
How can I fix this? When I change the values to text it converts the date to its numerical value 41667 for 28-Jan. Ideally I don't even care for the denominator. I just want it to give me the total number of students (numerator). Any help is appreciated.
<colgroup><col></colgroup><tbody>
</tbody>
The data below displays the number of students in a class.
For example, the first row displays 20 students out of 28.
Excel automatically converts some of the values to date such as 28-Jan (should be 1/28)
How can I fix this? When I change the values to text it converts the date to its numerical value 41667 for 28-Jan. Ideally I don't even care for the denominator. I just want it to give me the total number of students (numerator). Any help is appreciated.
20/28 |
30/28 |
29/28 |
28-Jan |
32/28 |
26/28 |
93/175 |
100/175 |
28-May |
28-Jan |
28-Jul |
<colgroup><col></colgroup><tbody>
</tbody>