I have a Google form intended to be filled out by teachers. One of the questions is about student ages. The choices are checkboxes with age ranges, so [ ] 0 - 5, [ ] 6 - 11 and so on.
The two ranges 6 - 11 and 12 - 14 show up formatted as dates, 11-Jun and 14-Dec, in the CSV spreadsheet. The others (0 - 5, 15 - 19, and 20+) show up as text. If I format the entire column as text, I get the numbers 43262 and 43448, which are presumably day numbers.
Since the munged content is predictable, I know I can fix this manually, but I'd surely like to prevent it from happening. How can I prevent this behavior?