Go Back   TechArena Community > Software > Windows Software
Become a Member!
Forgot your username/password?
Register Tags Active Topics RSS Search Mark Forums Read

Sponsored Links



[Excel] no increment date

Windows Software


Reply
 
Thread Tools Search this Thread
  #1  
Old 15-10-2008
Member
 
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?

Reply With Quote
  #2  
Old 15-10-2008
Member
 
Join Date: Apr 2008
Posts: 2,335
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.
Reply With Quote
  #3  
Old 15-10-2008
Member
 
Join Date: Dec 2007
Posts: 1,715
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.
Reply With Quote
  #4  
Old 15-10-2008
Member
 
Join Date: Apr 2008
Posts: 2,335
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
Reply With Quote
Reply

  TechArena Community > Software > Windows Software
Tags: , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "[Excel] no increment date"
Thread Thread Starter Forum Replies Last Post
Comparing the post increment and pre increment operators in C Programming Hebrew Software Development 6 16-12-2009 05:31 PM
PHP : Increment date in mysql Warner Software Development 3 02-07-2009 06:23 PM
Turn off auto increment in excel Laler Windows Software 2 16-05-2009 05:20 PM
Date Separator in Excel NIcaBoy Windows Software 2 25-03-2009 11:11 AM
Calculating date in Excel MarceloQuad Windows Software 2 16-03-2009 10:56 PM


All times are GMT +5.5. The time now is 09:05 AM.