+ Reply to Thread
Results 1 to 3 of 3

Macro to Change Dates in selected cells from Number to Short Date Format

  1. 03-02-2020, 10:42 AM #1
    sebi171
    sebi171 is offline
    Registered User
    Join Date
    12-05-2019
    Location
    West Palm Beach, FL
    MS-Off Ver
    2017
    Posts
    10

    Macro to Change Dates in selected cells from Number to Short Date Format

    Hello,

    I am looking for a Macro to change dates in selected cells from number to short date format.

    Thanks in advance!
    Reply With QuoteRegister To Reply
  2. 03-02-2020, 10:53 AM #2
    zzzeddy
    zzzeddy is offline
    Valued Forum Contributor
    Join Date
    08-03-2012
    Location
    Newcastle
    MS-Off Ver
    Excel 2007, 2010, 2013, 2016, Office 365
    Posts
    467

    Re: Macro to Change Dates in selected cells from Number to Short Date Format

    Hi

    If you have selected cells, then you could use this..
    Please Login or Register  to view this content.
    ..adjust accordingly

    zeddy
    Reply With QuoteRegister To Reply
  3. 03-02-2020, 11:32 AM #3
    sebi171
    sebi171 is offline
    Registered User
    Join Date
    12-05-2019
    Location
    West Palm Beach, FL
    MS-Off Ver
    2017
    Posts
    10

    Re: Macro to Change Dates in selected cells from Number to Short Date Format

    Thank you sir
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Excel Monthveiw Change the date format to Short Date
    By nigelog in forum Excel General
    Replies: 2
    Last Post: 09-09-2016, 12:38 PM
  2. DateValue VBA to change text in selected cells to actual dates
    By Gene@action in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-09-2015, 02:53 PM
  3. [SOLVED] Convert text to number and change date format in a macro.
    By Zimmerray1 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 01-15-2014, 07:04 PM
  4. Want to change the dates in selected cells manually using a MACRO
    By e4excel in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-07-2013, 03:22 AM
  5. Want to change the dates in selected cells manually using a MACRO
    By e4excel in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-04-2013, 02:12 PM
  6. [SOLVED] Change cells format when a value is selected
    By Rocky2013 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-04-2013, 06:15 AM
  7. Short dates coming up in US format if day is less then 13
    By [email protected] in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-13-2006, 08:00 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1