+ Reply to Thread
Results 1 to 3 of 3

Macro for changing the date from 02-Jan-1900 to 01-Jan-1900

  1. #1
    Registered User
    Join Date
    07-19-2013
    Location
    India
    MS-Off Ver
    Excel 2003
    Posts
    2

    Macro for changing the date from 02-Jan-1900 to 01-Jan-1900

    The date is saved as 01/01/1900 in Database. But when i pull a report and save it in excel the date 01/01/1900 changes to 02-Jan-1900 where it is suppose to be as 01-Jan-1900. But the other dates s per the database in report and excel. I m facing problem with this date 01-Jan-1900. Please help me to resolve it through macro.

  2. #2
    Valued Forum Contributor
    Join Date
    06-16-2006
    Location
    Sydney, Australia
    MS-Off Ver
    2013 64bit
    Posts
    1,394

    Re: Macro for changing the date from 02-Jan-1900 to 01-Jan-1900

    There are lots of strange things that happen in Excel in the year 1900.
    http://en.wikipedia.org/wiki/Year_1900_problem

    I don't think using a macro is a good idea. You really need to understand why it is happening and stop it (if you can). Why do you need this date anyway (out of interest)?
    My approach to providing help is to help you to help yourself. So my answers won't always solve your problem, but hopefully you can learn enough to solve the problem yourself and be more self sufficient for the experience.

  3. #3
    Registered User
    Join Date
    07-19-2013
    Location
    India
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: Macro for changing the date from 02-Jan-1900 to 01-Jan-1900

    Thanks for your reply
    Actually I use this date in my report for default cases.
    Any idea how to stop such issues.

    Example for the data in my reprot

    columnA
    08-Mar-1985
    02-Apr-1925
    02-Jan-1900
    02-Jan-1900

    I need the last two dates alone to be changes as 01-Jan-1900

+ 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. Excel 2007 : changing a defualt date (00/00/1900) to a blank
    By Icehockey44 in forum Excel General
    Replies: 9
    Last Post: 03-08-2012, 11:24 AM
  2. Date always Jan. 1900
    By L62H66 in forum Excel General
    Replies: 6
    Last Post: 01-30-2011, 09:19 PM
  3. Date defaults to 01/00/1900
    By mtbe in forum Excel General
    Replies: 7
    Last Post: 08-25-2009, 05:06 PM
  4. Date format pre-1900.
    By Craig & Co. in forum Excel General
    Replies: 1
    Last Post: 02-15-2005, 02: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