In A1 enter Jan-08 and drag till u want

it will show only Jan-08, at the end of the cursor u will autofill
option click for more option and then choose fill months

u will get the result as u need......




On Apr 6, 10:16*am, "Andrew Chalk"
wrote:
I have a column formatted as "Date" with format March-01, etc.

If I enter Jan-08 in A1 how do I get Feb=08 to appear in A2, etc ? I tried
A1+1 but the syntax is not understood by Excel 2003.

Many thanks.