+ Reply to Thread
Results 1 to 3 of 3

Change date format

  1. #1
    Registered User
    Join Date
    04-20-2020
    Location
    Kerala, India.
    MS-Off Ver
    Office 2016
    Posts
    11

    Change date format

    Dear all,

    I have elaborated the question in the sample workbook.

    Thank you.
    Attached Files Attached Files

  2. #2
    Forum Expert sweep's Avatar
    Join Date
    04-03-2007
    Location
    Great Sankey, Warrington, UK
    MS-Off Ver
    2003 / 2007 / 2010 / 2016
    Posts
    3,279

    Re: Change date format

    Hi,

    The following works for your example.

    =DATE(RIGHT(A2,4),LEFT(A2,2),MID(A2,4,2))
    Rule 1: Never merge cells
    Rule 2: See rule 1

    "Tomorrow I'm going to be famous. All I need is a tennis racket and a hat".

  3. #3
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: 2019 but still use also older versions
    Posts
    7,472

    Re: Change date format

    You can use:
    Please Login or Register  to view this content.
    and copy down

    other option is to use "text to columns" tool from data ribbon - make sure you mark column1 ad date with MDY format
    Attached Images Attached Images
    Last edited by Kaper; 06-23-2020 at 03:09 AM.
    Best Regards,

    Kaper

+ 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. change date format in VBA code it means change output when printing cheque
    By keshavtale in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-23-2019, 06:06 AM
  2. Change format to date format if cell populated with a date
    By Lbelden78 in forum Hello..Introduce yourself
    Replies: 2
    Last Post: 07-22-2019, 08:26 AM
  3. Show Error when a cell with number format change to date format
    By delroba in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-08-2015, 02:57 AM
  4. [SOLVED] Date formula - Change Format to YYYYMMDD from Exported Format
    By haleakala17 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-21-2014, 03:22 PM
  5. [SOLVED] help on vba code to change the error date format as standard format mm/dd/yyyy
    By johnodys in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-13-2013, 01:10 AM
  6. Not able to change date format into proper excel date format
    By excel5111987 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-18-2011, 08:19 AM
  7. Userform date format reverting back to us format on change event
    By jpruffle in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-10-2009, 12:34 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