Results 1 to 6 of 6
  1. #1
    5 Star Lounger
    Join Date
    Aug 2001
    Location
    NY, NY, USA
    Posts
    654
    Thanks
    10
    Thanked 0 Times in 0 Posts

    changing a column of numbers to date and reformat to a custom date

    This may already have been answered in the past, (but I don't see the post) but I would like to change all the numbers in one column to a regular date format
    Right now it is showing as a number. For example the number would be 19721024 which should read 10/24/1972 or similar and should show as a date cell versus a text cell or a general number cell.
    Is there a macro or code for this
    Thank you again
    JK

  2. #2
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    La Jolla, CA
    Posts
    1,470
    Thanks
    30
    Thanked 62 Times in 58 Posts
    Since that number, 19721024, isn't in a date format that Excel recognizes, you have to convert it to one.

    If the format is: yyyymmdd, then this will work for you (the actual numbers in column B are 26596 and 42374, respectively (if you care). Then, they are formatted using a date format.

    Clip0007.jpg

  3. #3
    5 Star Lounger
    Join Date
    Aug 2001
    Location
    NY, NY, USA
    Posts
    654
    Thanks
    10
    Thanked 0 Times in 0 Posts
    Quote Originally Posted by kweaver View Post
    Since that number, 19721024, isn't in a date format that Excel recognizes, you have to convert it to one.

    If the format is: yyyymmdd, then this will work for you (the actual numbers in column B are 26596 and 42374, respectively (if you care). Then, they are formatted using a date format.

    Clip0007.jpg
    Not certain what I am doing incorrectly see print screen attached. Many thanks

  4. #4
    5 Star Lounger
    Join Date
    Aug 2001
    Location
    NY, NY, USA
    Posts
    654
    Thanks
    10
    Thanked 0 Times in 0 Posts
    not certain what I am doing wrong see attached Thanks jk
    Attached Images Attached Images

  5. #5
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    La Jolla, CA
    Posts
    1,470
    Thanks
    30
    Thanked 62 Times in 58 Posts
    Now, format the N column as a date.

  6. #6
    5 Star Lounger
    Join Date
    Aug 2001
    Location
    NY, NY, USA
    Posts
    654
    Thanks
    10
    Thanked 0 Times in 0 Posts
    phenomenal thank you

Posting Permissions

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