ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   International dates are not recognised by autoformatting (https://www.excelbanter.com/excel-programming/372258-international-dates-not-recognised-autoformatting.html)

steve m

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




All times are GMT +1. The time now is 12:15 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com