excel 2010 incrementing numbers in a column

by puzzled   Last Updated November 15, 2017 07:01 AM

I want to increment numbers using the "pull-down" method [?], but when I try to do this, it increases the first number (the "year") NOT the "day" figure. e.g.,

1957 09 02

I want to pull & drag down this, so that the next cells down will read

1957 09 03
1957 09 04
1957 09 05

etc. but, what I get is

1958 09 02
1959 09 02
1960 09 02

etc.

It doesn't seem to matter what the column is formatted as, text, number – I cannot get it to act as I wish. ideas?



Related Questions


Listbox, mouse wheel scroll issue

Updated October 22, 2015 08:00 AM

Formula issue Microsoft Excel

Updated July 02, 2015 16:00 PM

If Difference Higher or Lower than Display

Updated August 03, 2015 15:00 PM


How to fix Excel Formula

Updated July 12, 2017 09:01 AM