|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.