I usually pre-set number formats and other limitations on forms to ensure
that I get the information that I need. Often, however, the date is vague and
requires text, e.g., Nov 2005 instead of 11/1/05, which is Excel's default if
you type in "Nov 2005." I can alleviate the issue on my own work, but my
forms need to remain locked when being used by others. My suggestion is that
an option be offered so a cell could take either/or text or number in the
case of dates.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...lic.excel.misc