I have a Google Forms with a question that contains a drop-down box with the following values:
- Fewer than 10 - 11-25 - 26-50 - More than 50
If the user selects
11-25, Google Sheets renders the response data like this:
Under the formats dropdown in the toolbar, selecting "Plain Text" has the cell render as this date. Selecting "Normal" gives just
40,872, and selecting any other type of format gives
980928:00:00, and other various numbers that aren't anything like
11-25, depending on what option I choose.
The workaround is to change the Forms response option to
11-25 apples, or to recognize when manipulating my data that '11/25/2011' really means '11-25 apples'.
But is there a way to get Google Sheets to stop turning
11-25 into a date?