+ Reply to Thread
Results 1 to 2 of 2

change dates macro

  1. #1
    Registered User
    Join Date
    02-08-2010
    Location
    London
    MS-Off Ver
    Excel 2007
    Posts
    52

    change dates macro

    Hi,

    I need to create a macro that will change the date for me. Basically any date where the day is less than 10 or the month is less than 10 I need to swap the day and month round, in the format dd/mm/yyyy. i.e. 12/05/2010 should change to 05/12/2010 and 03/06/2011 should change to 06/03/2011.

    I have a lot of files and even more cells to update so any help it much appreciated.

    Thanks!

  2. #2
    Forum Expert romperstomper's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    365, varying versions/builds
    Posts
    21,260

    Re: change dates macro

    X-post here, BTW.
    Remember what the dormouse said
    Feed your head

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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