Correcting dates

  • Hellu,


    I wonder if someone has any idea of how I can solve this little problem. I work against a main frame computer and this main fram delivers dates in the following format: 20051121.
    Does anyone know how to convert this date into a standard date format i.e. 2005-11-21 through VBA?


    :thanx:

    .¸¸·´¯'·.¸¸.·´¯'·.¸¸·´¯'·.¸¸.·´¯'·.¸¸·´¯'·.¸¸.· ><((((º>

  • Re: Correcting dates


    There's no need for VBA for this.


    Just select the column with the date, goto Data>Text to Columns..., on the 3rd step chose Date for the Column data format and YMD from the dropdown.


    That should convert the values into date values.

    Boo!:yikes:

  • Re: Correcting dates


    Thank you very much!
    :thanx:

    .¸¸·´¯'·.¸¸.·´¯'·.¸¸·´¯'·.¸¸.·´¯'·.¸¸·´¯'·.¸¸.· ><((((º>

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!