Results 1 to 2 of 2
  1. #1
    Lounger
    Join Date
    Oct 2004
    Posts
    31
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Date Problem (Excel 2003)

    Please review attchment.

    This report was imported to Excel from a main frame computer. Cell E2 ahd E3 is the Birth date field and should be date information. I want them in the following format 10/11/83 and 01/07/85. What are the steps to get them in this format??? Thanks in advance.....

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Date Problem (Excel 2003)

    If your date format is MMDDYY then issert a column with the following formula

    =DATE(RIGHT(E2,2),LEFT(E2,2),MID(E2,3,2))

    and copy down

    If your date format is DDMMYY use

    =DATE(RIGHT(E2,2),MID(E2,3,2),LEFT(E2,2)) instead

    You can then apply the appropriate date formatting to the column

    Andrew C

Posting Permissions

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