Results 1 to 12 of 12

"Dates" issue with US settings versus Dutch settings

Threaded View

  1. #1
    Forum Contributor
    Join Date
    07-26-2012
    Location
    Netherlands
    MS-Off Ver
    Excel 2016 Office 365 ProPlus
    Posts
    826

    "Dates" issue with US settings versus Dutch settings

    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.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Difficult macro to change regional settings from "Windows Compatibile" to US
    By jaryszek in forum Excel Programming / VBA / Macros
    Replies: 29
    Last Post: 02-01-2019, 02:55 PM
  2. [SOLVED] Where's the "Custom User Title" in Excel profile settings
    By GraeagleBill in forum Excel General
    Replies: 5
    Last Post: 01-08-2018, 06:47 AM
  3. Make permantent changes to Word "options" settings
    By Mallycat in forum Word Formatting & General
    Replies: 3
    Last Post: 04-21-2012, 04:31 AM
  4. Replies: 0
    Last Post: 12-07-2008, 01:25 PM
  5. [SOLVED] using "transparency" option on chart settings
    By Mike D in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 12-03-2005, 12:35 AM
  6. [SOLVED] How can I Copy "Page Setup" Settings between Workbooks
    By CJPodd in forum Excel General
    Replies: 2
    Last Post: 09-16-2005, 12:58 PM
  7. Deleting "Share Log" Filters & Print Settings for prior users
    By Nodak in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-10-2005, 09:06 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1