How to fix these dates?
Results 1 to 3 of 3

Thread: How to fix these dates?
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular
    Join Date
    Jul 2019
    Location
    Win 10, Office Professional Plus 2016
    Posts
    105
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default How to fix these dates?

    https://1drv.ms/x/s!AvjBsEPEq12ngTwwKMwIFJo5_Tk7?e=J87rl6


    How best could I go about fixing this column so that it shows dates.
    The bottom half is in text format.
    Thanks all.

  2. #2
    Board Regular Michael M's Avatar
    Join Date
    Oct 2005
    Location
    South Western NSW
    Posts
    17,679
    Post Thanks / Like
    Mentioned
    18 Post(s)
    Tagged
    2 Thread(s)

    Default Re: How to fix these dates?

    The link suggests they are simply left aligned ?
    Is there a leading apostrophe in the Text dates ?
    Put this formula in col "B" and copy down....if they are a date it will return true

    Code:
    =LEFT(CELL("format",A1))="D"
    Last edited by Michael M; Aug 20th, 2019 at 03:08 AM.
    Regards
    Michael M
    ---------------------------------------
    The more I learn, the less I seem to know.....A Please and Thank You cost nothing !
    It's easier to debug if we can see the whole macro !
    Home 2007 & 2013

    - Posting guidelines, forum rules and terms of use

    - To download Mr Excel HTML Maker

    - Try searching for your answer first, see how

    - Read the FAQs

    - List of BB codes


    [CODE]Place Your Code Here[/CODE]

  3. #3
    Board Regular
    Join Date
    Jul 2019
    Location
    Win 10, Office Professional Plus 2016
    Posts
    105
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: How to fix these dates?

    I uploaded the spreadsheet again.

    A2:A6 shows dates in MM/DD/YYYY format
    A7:A9 is in DD/MM/YYYY format but Excel doesn't recognize them as dates.

    When I sort, this is the output.
    Looking for a way to convert column A to dates.

    https://1drv.ms/x/s!AvjBsEPEq12ngTwwKMwIFJo5_Tk7?e=EqCqDj

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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