+ Reply to Thread
Results 1 to 4 of 4

Change existing date from mm/dd/yyyy to dd/mm/yyyy format without changing the position

  1. #1
    Registered User
    Join Date
    08-25-2015
    Location
    Kolkata, India
    MS-Off Ver
    2013
    Posts
    59

    Change existing date from mm/dd/yyyy to dd/mm/yyyy format without changing the position

    I have an excel sheet in which dates are appearing as 7/2/2019 and the excel is recognizing it as July 2, 2019 but I want it to be February 7, 2019. Please help.

  2. #2
    Forum Expert
    Join Date
    12-03-2009
    Location
    Florence, Italy
    MS-Off Ver
    Excel 2010
    Posts
    1,796

    Re: Change existing date from mm/dd/yyyy to dd/mm/yyyy format without changing the positio

    Hi

    an attempt: not sure...a service column to invert day and month

    =DATE(YEAR(A1),DAY(A1),MONTH(A1))

    formatted as mmmm, d yyyy

    Regards
    Last edited by canapone; 04-25-2019 at 10:26 AM.
    -----------------------------------------------------

    At Excelforum, you can say "Thank you!" by clicking the star icon ("Add Reputation") below the post.

    Please, mark your thread [SOLVED] if you received your answer.

  3. #3
    Forum Guru AlKey's Avatar
    Join Date
    07-20-2009
    Location
    Lakeland, FL USA
    MS-Off Ver
    Microsoft Office 2010/ Office 365
    Posts
    8,903

    Re: Change existing date from mm/dd/yyyy to dd/mm/yyyy format without changing the positio

    Or try this
    =--TEXT(A1,"d/mm/yyy") and format as Date
    v A B
    1 7/2/2019 2/7/2019
    If you like my answer please click on * Add Reputation
    Don't forget to mark threads as "Solved" if your problem has been resolved

    "Nothing is so firmly believed as what we least know."
    --Michel de Montaigne

  4. #4
    Registered User
    Join Date
    08-25-2015
    Location
    Kolkata, India
    MS-Off Ver
    2013
    Posts
    59

    Re: Change existing date from mm/dd/yyyy to dd/mm/yyyy format without changing the positio

    Thanks a ton. It worked

+ 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. How to change date format dd/mm/yyyy to mm/dd/yyyy ?
    By maddyrafi1987 in forum Excel - New Users/Basics
    Replies: 27
    Last Post: 05-13-2017, 02:23 AM
  2. Macro to change Date Format mm-dd-yyyy to dd-mm-yyyy
    By sriku in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-12-2014, 08:34 AM
  3. Replies: 8
    Last Post: 10-02-2013, 06:23 PM
  4. Date Format Change dd-mm-yyyy to dd-mon-yyyy
    By NAGRAJ in forum Excel General
    Replies: 3
    Last Post: 08-09-2013, 10:20 AM
  5. [SOLVED] Change date format from YYYY-MM-DD hh:mm:ss to YYYY-MM-DD
    By Gunilla in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-16-2012, 12:26 PM
  6. [SOLVED] how do I change date from mm/dd/yyyy to dd:mm:yyyy format in Excel
    By Jack Wilson in forum Excel - New Users/Basics
    Replies: 4
    Last Post: 07-18-2006, 09:00 AM
  7. [SOLVED] change date format from dd/mm/yyyy to mm/yyyy
    By flow23 in forum Excel General
    Replies: 2
    Last Post: 11-09-2005, 11:40 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