If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Copying Dates Question
I'm new to Excel and have a question. I can type in a date like this: 3-mar-09. Ok, then I can click the corner of the cell and copy that date to cell under that cell. However, it add a day and becomes: 4-mar-09. Is there any way to turn that off so I can type 3-mar-09 and copy that cell exactly like that without excel adding days? Thanks! |
#2
|
|||
|
|||
Copying Dates Question
To keep the same date, you will have to:
Use CtrlC and CtrlV; or enter it in two cells directly below each other, say A1:A2. Now select both cells, and then drag down as far as you want. -- HTH Kassie Replace xxx with hotmail "Von Fourche" wrote: I'm new to Excel and have a question. I can type in a date like this: 3-mar-09. Ok, then I can click the corner of the cell and copy that date to cell under that cell. However, it add a day and becomes: 4-mar-09. Is there any way to turn that off so I can type 3-mar-09 and copy that cell exactly like that without excel adding days? Thanks! |
#3
|
|||
|
|||
Copying Dates Question
"Kassie" wrote in message ... To keep the same date, you will have to: Use CtrlC and CtrlV; or enter it in two cells directly below each other, say A1:A2. Now select both cells, and then drag down as far as you want. Nice. Thanks. |
#4
|
|||
|
|||
Copying Dates Question
Enter the date in A1
Right-click on the fill handle and drag dowm. Release and "Copy Cells" Gord Dibben MS Excel MVP On Sat, 5 Sep 2009 02:48:25 -0400, "Von Fourche" wrote: I'm new to Excel and have a question. I can type in a date like this: 3-mar-09. Ok, then I can click the corner of the cell and copy that date to cell under that cell. However, it add a day and becomes: 4-mar-09. Is there any way to turn that off so I can type 3-mar-09 and copy that cell exactly like that without excel adding days? Thanks! |
#5
|
|||
|
|||
Copying Dates Question
Try right-click and drag, Kassie
A couple of steps easier. Gord Dibben MS Excel MVP On Sat, 5 Sep 2009 00:26:01 -0700, Kassie wrote: To keep the same date, you will have to: Use CtrlC and CtrlV; or enter it in two cells directly below each other, say A1:A2. Now select both cells, and then drag down as far as you want. |
#6
|
|||
|
|||
Copying Dates Question
Thanks gord, you see, you are never too old to learn something new!
-- HTH Kassie Replace xxx with hotmail "Gord Dibben" wrote: Try right-click and drag, Kassie A couple of steps easier. Gord Dibben MS Excel MVP On Sat, 5 Sep 2009 00:26:01 -0700, Kassie wrote: To keep the same date, you will have to: Use CtrlC and CtrlV; or enter it in two cells directly below each other, say A1:A2. Now select both cells, and then drag down as far as you want. |
#7
|
|||
|
|||
Copying Dates Question
Every day I learn something new and I'm getting pretty long in the toothg
These news groups are great. Gord On Sat, 5 Sep 2009 13:05:01 -0700, Kassie wrote: Thanks gord, you see, you are never too old to learn something new! |
Thread Tools | |
Display Modes | |
|
|