Ok so my windows has Dutch regional settings, some of my colleagues have US settings.
Following should work in either situation.
Please see excel attached.
There is a column (A) with date time and AM/PM CET setup.
I need to lose the CET (with replace that is easy) so excel will see the field as a normal date field.
However after this (see column D) the lines with Feb nicely go to a "8-2-2019" format, however for me the line with 11-Mar-2019 will not convert as month 3 would not be Mar but Mrt in my settings.
How can I get this to work without regional settings being an issue?
Thanks.
Bookmarks