+ Reply to Thread
Results 1 to 4 of 4

Date format

  1. #1
    Registered User
    Join Date
    11-23-2016
    Location
    Slovakia
    MS-Off Ver
    2016
    Posts
    26

    Date format

    Hi guys, What can I do if I have many dates in database but a few of them were format like a text. I change format to date. But when I click on filter they are not sort to years. I tried to select column and changed format but nothing.date.PNG

  2. #2
    Forum Contributor
    Join Date
    02-07-2013
    Location
    Karachi, Pakistan
    MS-Off Ver
    Excel 2007
    Posts
    290

    Re: Date format

    Hi,

    Use a helper column with following and then replace the result:
    =SUBSTITUTE(A1,".","/")+0

    or use text to column wizard.

    Regards,
    Khalid

  3. #3
    Forum Guru samba_ravi's Avatar
    Join Date
    07-26-2011
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2021
    Posts
    8,904

    Re: Date format

    Select the cells
    DATA>text to columns>delimited>next>next>select date>under date select DMY >finish
    Samba

    Say thanks to those who have helped you by clicking Add Reputation star.

  4. #4
    Registered User
    Join Date
    11-23-2016
    Location
    Slovakia
    MS-Off Ver
    2016
    Posts
    26

    Re: Date format

    thanks +rep

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Converting from the 1904 date format to the 1900 date format without losing data
    By Patty McJorst in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-01-2020, 12:53 PM
  2. Replies: 4
    Last Post: 04-29-2015, 08:36 AM
  3. Date Format Of User PC Changes Display format date of Excel File after update
    By waihar in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-24-2014, 03:09 AM
  4. Replies: 5
    Last Post: 02-08-2013, 11:06 AM
  5. Need Formula/VBA Code to convert date in String Format to Normal Date format
    By Karthik Sen in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-18-2012, 04:54 AM
  6. Column Range with date Format MM/DD/YYYY independate of sys date Format
    By gaursh in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-18-2011, 03:31 AM
  7. Replies: 1
    Last Post: 03-30-2005, 02:06 AM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1