Microsoft KB Archive/215193

= XL: Dates Are Not Incremented Properly When You Fill Large Ranges =

Article ID: 215193

Article Last Modified on 1/24/2007

-

APPLIES TO


 * Microsoft Excel 2000 Standard Edition
 * Microsoft Excel 2001 for Mac

-



This article was previously published under Q215193



SYMPTOMS
When you fill a large range of cells from a cell that is formatted with the Date format, the dates in the filled range are not incremented as you expect.



WORKAROUND
To work around this behavior, use the Series command to fill large ranges with dates. To do this, follow these steps:
 * 1) Start Microsoft Excel, and create a new, blank workbook.
 * 2) Click the cell that you want to format with Date formatting.
 * 3) On the Format menu, click Cells.
 * 4) On the Number tab, click Date in the Category list.
 * 5) In the Type list, click the date format that you want, and then click OK.
 * 6) Type the number that you want in the cell that you formatted with the Date format, and then press ENTER.
 * 7) Click the cell from step 6.
 * 8) On the Edit menu, point to Fill, and then click Series.

Notice that the Series dialog box appears.
 * 1) Under Series in, click Rows if you want to fill a row, or click Columns if you want to fill a column.
 * 2) Under Type, click Date, and then under Date unit, click the date format that you want.
 * 3) In the Step value box, type the number by which you want to increment the series.
 * 4) In the Stop value box, type the number that you want to use as the end value of the series.
 * 5) Click OK.

Notice that the series is filled with dates, and that the dates are incremented correctly throughout the series.



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

Additional query words: XL2001 XL2000

Keywords: kbpending kbprb KB215193

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.