Fred A. Miller wrote: > Jeff Sherk - Kingdom Alarms wrote: >> --- Clois Beckwith <[EMAIL PROTECTED]> wrote: >> >>>I have been using Microsoft Excel for 10 plus years and I can't >>>quite figure >>>out how to autofill in the following format: >>>Dec, 05 >>>Nov,05 >>>Oct,05 >>>etc. >> >> >> Here are a couple of suggestions. I am still using Version 2.0.2, but >> they should still work with 2.0.3: > > [snip] > > An easy way, is to define your date format for the entier callumn first. > Enter the date in the first cell. Enter a formula to read the fist cell > and add 1. Replicate that 2nd cell to complete that month. Then, do the > same for other months. > > Fred
For month only on a mmmm, yyyy formated cell add 31 instead of 1 and it will fill it in as February, 2006, March, 2006 etc. Works for the full year and will even carry on to the next year (2007 etc). --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
