Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]()
I want to enter a month & year in a cell (i.e. Dec-04), and have the next 60
months auto-fill. |
#2
![]() |
|||
|
|||
![]()
Dates in Excel have to be an exact day or else you have
to create them as text. I suggest you insert: 12/1/04 and right-click on the fill handle and drag for 60 cells. Release the right-click button and select: Fill Months Now format your cells as mmm-yy. HTH Jason Atlanta, GA -----Original Message----- I want to enter a month & year in a cell (i.e. Dec-04), and have the next 60 months auto-fill. . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Auto fill of formula | Excel Worksheet Functions | |||
auto fill series | Excel Discussion (Misc queries) | |||
Fill dates with weekdays/workdays only | Excel Worksheet Functions | |||
Auto fill box | Excel Discussion (Misc queries) | |||
Auto Fill Options | Excel Discussion (Misc queries) |