I'm trying to create a column with Jan-2001 to Dec-2001.
How do I format this?
Thank you,
I'm trying to create a column with Jan-2001 to Dec-2001.
How do I format this?
Thank you,
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"
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks