+ Reply to Thread
Results 1 to 6 of 6

convert 9/27/2012 12:00:00 AM in dd/mm/yyyy format

  1. #1
    Registered User
    Join Date
    07-27-2018
    Location
    Jodhpur
    MS-Off Ver
    MS Office 2019
    Posts
    75

    convert 9/27/2012 12:00:00 AM in dd/mm/yyyy format

    HI,

    need to convert 9/27/2012 12:00:00 AM in dd/mm/yyyy format. Please suggest a excel formula.
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    04-27-2015
    Location
    Abu Dhabi, U.A.E
    MS-Off Ver
    Office 365 | 2016
    Posts
    683

    Re: convert 9/27/2012 12:00:00 AM in dd/mm/yyyy format

    The given date in the sheet is not in a date format.
    use the below formula in Cell C2 and drag it down.

    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Attached Files Attached Files

  3. #3
    Valued Forum Contributor
    Join Date
    09-25-2015
    Location
    Milan Italy
    MS-Off Ver
    office 365
    Posts
    1,041

    Re: convert 9/27/2012 12:00:00 AM in dd/mm/yyyy format

    c2=IF(B2<>"",INT(VALUE(B2)),"")

    copy down

    custom format dd/mm/yyyy
    Last edited by CARACALLA; 03-15-2020 at 06:45 AM.

  4. #4
    Registered User
    Join Date
    07-27-2018
    Location
    Jodhpur
    MS-Off Ver
    MS Office 2019
    Posts
    75

    Re: convert 9/27/2012 12:00:00 AM in dd/mm/yyyy format

    Thank you! Shareez Saleem. Bro, you have solved my problem.

  5. #5
    Forum Expert BMV's Avatar
    Join Date
    01-13-2020
    Location
    St-Petersburg, Russia
    MS-Off Ver
    2013-2016
    Posts
    1,262

    Re: convert 9/27/2012 12:00:00 AM in dd/mm/yyyy format

    Quote Originally Posted by CARACALLA View Post
    c2=IF(B2<>"",INT(VALUE(B2)),"")
    it depends on regional settings

    Please Login or Register  to view this content.

  6. #6
    Registered User
    Join Date
    07-27-2018
    Location
    Jodhpur
    MS-Off Ver
    MS Office 2019
    Posts
    75

    Re: convert 9/27/2012 12:00:00 AM in dd/mm/yyyy format

    BMV Bro! Yes, it is also worked. Thanks a lot.

+ 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. Convert Date in DD.MM.YYYY to DD/MM/YYYY format
    By abhinavbinkar in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 01-21-2019, 07:18 AM
  2. Convert Date format from Text format reading m/d/yyyy to dd/mm/yyyy
    By bridge4444 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-23-2017, 11:22 PM
  3. [SOLVED] How to Convert date format ( DD/MM/YYYY) into MM/YYYY
    By PRADEEPB270 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-04-2014, 07:25 AM
  4. [SOLVED] Trying to convert Date Format - Wed Sep 26 2012 05:03:42 GMT+0000 (UTC) to 26/09/2012
    By BEEGINA in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 05-03-2013, 10:43 AM
  5. [SOLVED] convert MM/DD/YYYY to DD/MM/YYYY while the data format is text
    By Vogelmann in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 10-18-2012, 02:43 PM
  6. [SOLVED] Imported data contains strings dd.mm.yyyy how can I convert to date format dd/mm/yyyy inVB
    By Boormo in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 09-05-2012, 05:48 PM
  7. Macro to convert dates format from yyyy mm dd to yyyy-mm-dd
    By Gators in forum Excel Programming / VBA / Macros
    Replies: 19
    Last Post: 02-26-2009, 02:23 PM

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