Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel should support the ISO standard date format
ISO 8601 standardizes the format of dates written using only numbers. Excel
2003 does not support this format, so I have to write dates as text. This sucks. More information: http://www.iso.org/iso/en/commcentre...fe_2.html#date ---------------- 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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel should support the ISO standard date format
Excel supports the format.
You have to create a custom number format for it to work. -- Brevity is the soul of wit. "James the Standards Man" wrote: ISO 8601 standardizes the format of dates written using only numbers. Excel 2003 does not support this format, so I have to write dates as text. This sucks. More information: http://www.iso.org/iso/en/commcentre...fe_2.html#date ---------------- 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Mileage Claim Formula | New Users to Excel | |||
Excel: I enter date and format for date, but shows as number | Excel Discussion (Misc queries) | |||
Excel keeps converting text to date format | Excel Discussion (Misc queries) | |||
Excel default date format | Excel Discussion (Misc queries) | |||
Excel enters date as a text format | Excel Discussion (Misc queries) |