Results 1 to 4 of 4
  1. #1
    2 Star Lounger
    Join Date
    Dec 2002
    Posts
    192
    Thanks
    0
    Thanked 0 Times in 0 Posts

    dates without /'s (2000)

    Hi
    I know someone posted this question not to long ago, but I cannot find it. What is the formula to convert a number into a date? I want to just type 120604 without / and the formula will convert it to 12/06/04.
    Thanks

  2. #2
    Silver Lounger
    Join Date
    Dec 2000
    Location
    California, USA
    Posts
    1,758
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: dates without /'s (2000)

    Try this: be sure when you enter the date (120604) in cell B4 it is six characters in length otherwise the formula will not work.

    John

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

    Re: dates without /'s (2000)

    Is this the <!post=Thread,462178>Thread<!/post> you are looking for?
    Legare Coleman

  4. #4
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: dates without /'s (2000)

    Heres a bit of info I found in my archive!
    (see attachment)
    Regards,
    Rudi

Posting Permissions

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