Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    Join Date
    Jan 2001
    Posts
    159
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Converting Dates

    In Excel 97, I have a field with dates 20000403. No format is selected. (Trust me, I didn't design the spreadsheet - just inherited it!!!). I need to prepare this information for exporting to Access database. How can I convert the field to a format of 04-03-2000?

    Thanks!

  2. #2
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Converting Dates

    If the value is in A1, then the formula below will do it:

    <pre>=MID(A1,5,2)&"-"&RIGHT(A1,2)&"-"&LEFT(A1,4)
    </pre>

    Legare Coleman

Posting Permissions

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