+ Reply to Thread
Results 1 to 9 of 9

Excel mixup day and month on different system...

  1. #1
    Registered User
    Join Date
    01-10-2013
    Location
    Canada
    MS-Off Ver
    Excel 2010
    Posts
    10

    Excel mixup day and month on different system...

    Hi all!

    I'm so confused right now... and hope you can help.

    I'm extracting some data from the ERP system to excel and generating the attached report.

    On my computer there is no problem I can easely play with the dates (sort, filter.. weeknum.. year..)

    BUT my collegues are not able.. it mixup the day and month of the dates.. not all dates but sometimes to times and anywhere (no obvious patern)


    My question is.. did you experience this kind of problem? if yes how did you solved it?

    Thanks a lot,
    GC

    updated 2014 04 11_forum.xlsm

  2. #2
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,643

    Re: Excel mixup day and month on different system...

    Hi and welcome to the forum.

    The operating system's Regional Setting determines how Excel interprets dates from an imported file.

    Canada uses dd/mm/yyyy

    USA uses mm/dd/yyyy

    Do your colleagues use a different Regional Setting than yours?
    Surround your VBA code with CODE tags e.g.;
    [CODE]your VBA code here[/CODE]
    The # button in the forum editor will apply CODE tags around your selected text.

  3. #3
    Registered User
    Join Date
    01-10-2013
    Location
    Canada
    MS-Off Ver
    Excel 2010
    Posts
    10

    Re: Excel mixup day and month on different system...

    yes they are, some in canada, usa, china, chili and malaysia..

    Am I screwed because of this?

  4. #4
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,643

    Re: Excel mixup day and month on different system...

    Quote Originally Posted by crx4me View Post
    yes they are, some in canada, usa, china, chili and malaysia..

    Am I screwed because of this?
    Not necessarily.

    You could import the data differently (use Data\Import Data where you can define a column's date format).

    Or if possible, configure your ERP system to output a Long date format e.g.: Jan 1, 2014 where the month is non numeric so it's not interpreted as a day.

    Or you could import the data on your computer and save as an Excel file. Then distribute the excel file.
    Last edited by AlphaFrog; 04-11-2014 at 12:05 AM.

  5. #5
    Registered User
    Join Date
    01-10-2013
    Location
    Canada
    MS-Off Ver
    Excel 2010
    Posts
    10

    Re: Excel mixup day and month on different system...

    for some reason I cannot format from the ERP.

    Is the a way via VBA to format the date to be readable for my colleagues?

  6. #6
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,643

    Re: Excel mixup day and month on different system...


  7. #7
    Registered User
    Join Date
    01-10-2013
    Location
    Canada
    MS-Off Ver
    Excel 2010
    Posts
    10

    Re: Excel mixup day and month on different system...

    thanks but the problem is that it's not a CSV file, it is directly exported to excel in this format.. :S

  8. #8
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,643

    Re: Excel mixup day and month on different system...

    Quote Originally Posted by crx4me View Post
    thanks but the problem is that it's not a CSV file, it is directly exported to excel in this format.. :S
    Can you better explain what "directly exported" means? Do the colleges also get the "direct export"?

  9. #9
    Registered User
    Join Date
    01-10-2013
    Location
    Canada
    MS-Off Ver
    Excel 2010
    Posts
    10

    Re: Excel mixup day and month on different system...

    the ERP system export and format directly into a Excel Worksheet not CSV, I 'm cleanning the report a bit, adding and removing some stoff and them I'm sending the final report to my collegues

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Help with a system to auto populate month names based on current month
    By rosboy in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-01-2012, 05:17 PM
  2. [SOLVED] VBA to identify the current month and previous month based on system date
    By ravikumar00008 in forum Excel General
    Replies: 10
    Last Post: 07-26-2012, 10:04 AM
  3. Replies: 1
    Last Post: 07-12-2012, 02:33 PM
  4. Mixup between thousand separator and decimal point in Eurpeean Excel.
    By Jiser001 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 11-02-2009, 05:11 AM
  5. Translation Mixup
    By mudraker in forum The Water Cooler
    Replies: 1
    Last Post: 11-01-2008, 09:11 PM

Tags for this Thread

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