Excel will not fill in the months

[Guest]

Appearently Excel refuses to fill in the months. After having typed January
in cell A2, selected cell A2, placed the pointer in the bottom right corner
of the cell and then dragging downwards, the rest of the months do NOT fill
in. For numbers it DOES work, though.
This is part of the online training course at:

http://office.microsoft.com/training/training.aspx?AssetID=RC010437481033

A little help would be appreciated. I am using Excel 2003.

Simon Tofte

 

[Bernie Deitrick]

Simon,

Check Tools / Options... "Custom Lists" tab, and make sure that you have a list "January,
February,..."

If you don't have it, you will need to create it.

HTH,
Bernie
MS Excel MVP

 

[Karthik]

This is one way to do it.
Say you want to write Jan to Dec in Cells A1 to A12. Enter the
following formulas in A1 to A12

1
=+A1+31
=+A2+31
=+A3+31
=+A4+31
=+A5+31
=+A6+31
=+A7+31
=+A8+31
=+A9+31
=+A10+31
=+A11+31

Now set the format of these cells to Month. To do this Select A1 to
A12.Format> Cells>Custom, In the "Type:" box type MMMM
and click OK.
With this you have only changed the format, the actual data is not the
name of the months. To convert this into text copy : paste it in note
pad or word and then copy: paste it back to excel.

The easiest way : You write all the 12 Months once.

Thanks
Karthik Bhat
Bangalore