Share via

date format problem

Anonymous
2014-03-16T03:41:40+00:00

hi every one hope u all r doing nice there. i have some date format problems my erp softwear provide my delivery date like bellow my computer setting & all data sate date format like dd/MMM/yyyy now i want to to convert erp date data to dd/mmm/yyyy how to do this. this is how erp softwear date like bellow

3/13/2014 9:43:58 AM will be like 13-Mar-2014
3/15/2014 12:12:38 PM will be like 15-Mar-2014
03.03.14 10:11 will be like 03-Mar-2014
03.09.14 16:35 will be like 09-Mar-2014
03.05.14 19:21
03.05.14 19:22
03.11.14 9:26
2/22/2014 2:26:42 PM

 now how to do this please help

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

16 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Ashish Mathur 101.9K Reputation points Volunteer Moderator
    2014-03-16T06:24:10+00:00

    Hi,

    Select the data and get the Auto Filter icon.  In the Auto Filter drop down, go to Date Filters (or Text filters) > Custom and then type *

    Was this answer helpful?

    0 comments
  2. Anonymous
    2014-03-16T06:15:42+00:00

    how to apply step 7

    Was this answer helpful?

    0 comments
  3. Ashish Mathur 101.9K Reputation points Volunteer Moderator
    2014-03-16T05:50:51+00:00

    Hi,

    Step number 4 is to type space and start in the Find What box.

    Was this answer helpful?

    0 comments
  4. Anonymous
    2014-03-16T05:49:39+00:00

    after applying your 2nd formula result coming bellow

    01.03.13 16:18 2-Jun-70
    4/24/2013 2:28:12 PM 24-Apr-13
    01.11.13 11:30 26-Jun-50
    1/17/2013 5:21:57 PM 17-Jan-13
    6/17/2013 6:36:31 PM 17-Jun-13
    01.02.13 14:59 30-May-65
    01.03.13 19:42 2-Jun-85
    2/13/2013 4:27:50 PM 13-Feb-13
    1/17/2013 5:30:02 PM 17-Jan-13
    01.10.13 14:44 23-Jun-64
    1/30/2013 7:44:58 PM 30-Jan-13
    1/21/2013 9:23:15 AM 21-Jan-13
    01.02.13 19:28 30-May-84
    01.09.13 15:53 20-Jun-69
    01.05.13 15:44 8-Jun-68
    1/26/2013 5:13:44 PM 26-Jan-13
    1/17/2013 5:23:38 PM 17-Jan-13
    01.09.13 18:14 20-Jun-78
    01.03.13 19:28 2-Jun-84
    01.06.13 18:20 11-Jun-79
    01.02.13 18:27 30-May-79
    01.02.13 18:31 30-May-80
    1/16/2013 10:56:29 AM 16-Jan-13
    1/23/2013 3:04:17 PM 23-Jan-13
    02.01.13 14:52 27-May-64
    1/30/2013 6:44:15 PM 30-Jan-13
    02.09.13 12:26 20-Jun-54
    04.02.13 16:23 30-May-71
    01.09.13 16:05 20-Jun-70
    01.09.13 16:06 20-Jun-70
    01.09.13 15:49 20-Jun-68
    1/22/2013 6:22:48 PM 22-Jan-13
    1/22/2013 6:19:30 PM 22-Jan-13
    1/23/2013 8:01:16 PM 23-Jan-13
    1/19/2013 6:51:42 PM 19-Jan-13
    5/25/2013 11:13:16 AM 25-May-13
    01.10.13 12:11 23-Jun-53
    01.10.13 12:04 23-Jun-53
    01.02.13 19:39 30-May-84
    01.02.13 19:42 30-May-85

    Was this answer helpful?

    0 comments
  5. Deleted

    This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

    Comments have been turned off. Learn more