Fill Series Dates: not letting me change the series from year to m



Hi, I am using 2003 and was copying a series of dates from a spreadsheet (
2003) into a new spreadsheet. I then wanted to use the Fill Series to
display ascending months on these dates e.g. 01/01/2008, 02/01/2008 etc.
However, it is only doing the years in a series. I went into Edit>Fill Series
and selected DATE and MONTH as my settings but still no joy.

Is their some settings that is preventing me from changing the series



Rick Rothstein \(MVP - VB\)

Check the entry in the cells after the copy process... I think you will find
an apostrophe in front of each "date" meaning they are not dates, but text
that looks like a date. If you remove the apostrophes, it should then work
as you expect.


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question