Categories: Sheets :

How do you undo the automatic-date formatting?

Showing 1-3 of 3 messages
How do you undo the automatic-date formatting? sjsharks123 12/2/09 3:52 PM
I'm using a form for survey responses.  Some of the responses to a question are "1-2", "3-5", etc.  Whenever someone gives any of these inputs, the spreadsheet automatically converts it to "1/2/09" or "3/5/09".  Though I can see a summary of the results correctly, this is very annoying.  How do I undo this formatting?
 
Thanks for the help.





Re: How do you undo the automatic-date formatting? Gill 12/3/09 9:12 AM
Format the column into which the data is going as plain text. Last item on the 123 menu.
Re: How do you undo the automatic-date formatting? LaughDonor 12/3/09 9:14 AM
Format those cells to "Plain Text".. in the pulldown menu "123" it's at the very bottom.