[Excel] no increment date

[Florian]

Sponsored Links

I currently have a problem with Excel.
I have a column reserved for the date format DD / MM / YYYY.
When I want him to recopy the date on several lines of the column, it increments.

I explain, it is the 14/10/2008, if I requests a recopy of the date on two lines, it will save me 15/10/2008 and 16/10/2008 instead of the same date as above .

How can I change this?

[deoWo]

I tend to write 3 or 4 times the current date by hand, one below the other.
Then select group of cells
And then uses the cross (which is used to copy) and drag it as far as necessary.

Normally, excel should be based on the model you propose:
It will "see" a series of dates is identical establishment of the coup he will be content to copy without increment.

[Birdie]

We must add dollar signs to the letters and numbers that Excel will not increment. For example, in your first line in the box A1 you put the date in the second, you put $ A = $ 1. After you should not have a problem to expand.

[deoWo]

Originally Posted by Birdie

We must add dollar signs to the letters and numbers that Excel will not increment. For example, in your first line in the box A1 you put the date in the second, you put $ A = $ 1. After you should not have a problem to expand.

Ok!

Incidentally, I just checked in Excel: The technique that works perfectly