| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
International dates are not recognised by autoformatting
Take some data from the clipboard with dates such as 28/01/2006 (28th of
January) as well as ones that happen to come out looking like U.S. format dates 06/07/2006 (6th of July, not 7th of June) and apply autoformatting. The dates that look like U.S. dates are right-justified and the ones that look invalid are left justified / not recognised as dates. All the correct regional settings are in place, for U.K. in this instance. Is there a fix for this somewhere, please? regards, steve m |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 Not Autoformatting Dates | Excel Discussion (Misc queries) | |||
| dates not recognised | Excel Discussion (Misc queries) | |||
| Excel autoformatting dates | Excel Discussion (Misc queries) | |||
| How do I set dates to ISO INternational? | Excel Discussion (Misc queries) | |||
| How do I stop Excel 2002 from autoformatting numbers into dates? | Excel Discussion (Misc queries) | |||
Linear Mode
