![]() |
Excel cells should take number format and/or optional text eg Dec.
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 |
All times are GMT +1. The time now is 07:04 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com