+ Reply to Thread
Results 1 to 2 of 2

Excel 2007 : Date Format Help

  1. #1
    Registered User
    Join Date
    04-13-2007
    Posts
    2

    Date Format Help

    I'm trying to create a column with Jan-2001 to Dec-2001.
    How do I format this?

    Thank you,

  2. #2
    Forum Guru teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,364

    Re: Date Format Help

    Using your standard date format, enter in the first cell

    1-Jan-2001

    and in the next cell

    1-Feb-2001

    select both cells and drag the fill handle down until it reaches December

    Set the format of the cells to custom "MMM-YYYY"

+ 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