+ Reply to Thread
Results 1 to 3 of 3

Macro to change Date Format mm-dd-yyyy to dd-mm-yyyy

  1. #1
    Registered User
    Join Date
    04-27-2014
    Location
    india
    MS-Off Ver
    Excel 2010
    Posts
    54

    Macro to change Date Format mm-dd-yyyy to dd-mm-yyyy

    Hi ,

    Can any one suggest macro to changing the date format from mm-dd-yyy to dd-mm-yyy


    Thanks,

  2. #2
    Valued Forum Contributor
    Join Date
    01-19-2012
    Location
    Barrington, IL
    MS-Off Ver
    Excel 2007/2010
    Posts
    1,211

    Re: Macro to change Date Format mm-dd-yyyy to dd-mm-yyyy

    Record yourself setting the format and use that code.
    You should hit F5, because chances are I've edited this post at least 5 times.
    Example of Array Formulas
    Quote Originally Posted by Jacc View Post
    Sorry, your description makes no sense. I just made some formula that looks interesting cause I had nothing else to do.
    Click the * below on any post that helped you.

  3. #3
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,406

    Re: Macro to change Date Format mm-dd-yyyy to dd-mm-yyyy

    If your data are dates you don't need to change between formats. Just right click on cell(s) and format as you like.

+ 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. Replies: 8
    Last Post: 10-02-2013, 06:23 PM
  2. 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
  3. [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
  4. 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
  5. [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