Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Excel shouldn't bitch about a "date format" when formatted as txt
So, when I want a date to display as, say, 7/15 and the over aggressive
autoformat kicks in, I change the cell format to Text, which is supposed to 'displays exactly as typed.' Bingo, perfect. But then when I type in "7/15" I still get a formula error message. That's stupid. Make it stop. ---------------- 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Format date in excel 2000 like '31st January 2005' | Excel Discussion (Misc queries) | |||
Format date in excel 2000 like '31st January 2005' | Excel Discussion (Misc queries) | |||
Format date in excel 2000 like '31st January 2005' | Excel Discussion (Misc queries) | |||
Excel Query Wizard Date Format | Excel Discussion (Misc queries) | |||
Format Cells - Date options | Excel Discussion (Misc queries) |