Results 1 to 4 of 4

Thread: [Excel] no increment date

  1. #1
    Join Date
    May 2008
    Posts
    42

    [Excel] no increment date

    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?

  2. #2
    Join Date
    Apr 2008
    Posts
    2,353
    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.

  3. #3
    Join Date
    Dec 2007
    Posts
    1,731
    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.

  4. #4
    Join Date
    Apr 2008
    Posts
    2,353
    Quote Originally Posted by Birdie View Post
    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

Similar Threads

  1. Replies: 6
    Last Post: 16-12-2009, 05:31 PM
  2. PHP : Increment date in mysql
    By Warner in forum Software Development
    Replies: 3
    Last Post: 02-07-2009, 06:23 PM
  3. Turn off auto increment in excel
    By Laler in forum Windows Software
    Replies: 2
    Last Post: 16-05-2009, 05:20 PM
  4. Date Separator in Excel
    By NIcaBoy in forum Windows Software
    Replies: 2
    Last Post: 25-03-2009, 11:11 AM
  5. Calculating date in Excel
    By MarceloQuad in forum Windows Software
    Replies: 2
    Last Post: 16-03-2009, 10:56 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •