none
Default date and time format RRS feed

  • Question

  • I open dozens of csv and spreadsheets each day.  I often need the date format to be dd/mmm/yy   hh:mm:ss.

    Is there a way to add a hot key to change the format, set this format to default, or at least add it to the date time format list so that I do not have to create it each and every time?

    Monday, September 9, 2019 3:26 PM

All replies

  • To:  Redmutt
    re:  custom format in cells

    You can use the code below.
    Add a new button on the Quick Access Toolbar or add a shortcut key to run it.
    Select the contiguous cells you want to change before running the code.
    '---

    Sub ChangeFormat()
    Excel.Selection.NumberFormat = "dd/mmm/yy   hh:mm:ss"
    End Sub
    '---

    Free Custom_Functions Excel add-in (19 new functions) at MediaFire...
    http://www.mediafire.com/folder/lto3hbhyq0hcf/Documents

    Monday, September 9, 2019 5:53 PM