+ Reply to Thread
Results 1 to 2 of 2

Excel Date problem

  1. #1
    Registered User
    Join Date
    Waterford, Ireland
    MS-Off Ver
    Excel 2003

    Excel Date problem


    I was hoping someone could help with a problem with excel.

    I have a macro created to build a report for me, this is a Week to Date report so the first day it runs for 1 day the next it runs for 2 and so on throughout the week.

    How it works out what day it is and how many days to run for is built in however I am having a problem with the exported data opening in an American Date format. When the exported data is opened manually by double clicking the csv it opens fine in the european format but when the macro opens the csv it opens in the american format.

    This is a huge problem because the macro works out what day it is by formatting the date to a general number and using that as a baseline, however if you convert the same date from two seperate formats you get two different outcomes. Example: 14/03/2008 becomes 39521 but 03/14/2008 stays as 03/14/2008

    If anyone knows how to get the dates to open as European dates that would be great, also Regional settings have been checked and it is set to European.

  2. #2
    Valued Forum Contributor mudraker's Avatar
    Join Date
    Melbourne, Australia

    Re: Excel Date problem

    This type of problem was raised by another member several days ago


    Please Read Forum Rules Before Posting
    Wrap VBA code by selecting the code and clicking the # icon or Read This
    How To Cross Post politely

    Top Excel links for beginners to Experts

    If you are pleased with a member's answer then use the Scales icon to rate it
    If my reply has assisted or failed to assist you I welcome your Feedback.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread


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