Excel copy the same date in an entire column
Solved
spaceeric
Posted messages
77
Status
Member
-
Saida -
Saida -
Hello,
Here's a question c.. , everything is in the title, how can I copy a date across all the rows of a column in Excel?
For example, I enter "0000-00-00 00:00:00" for the date and time and I place my cursor at the bottom right and click and drag to stretch the column down to duplicate it, the problem is I end up with 0000-00-00 00:00:01 in the second row, 0000-00-00 00:00:02 in the third row, etc.
Copying and pasting cell by cell works perfectly fine! The only problem is I have 110,000 rows and I don't plan to do this for the next 15 days lol
Does anyone have the solution?
Configuration: Windows 7 / Firefox 3.6.13
--
Close your eyes, and the world becomes what you want.
Here's a question c.. , everything is in the title, how can I copy a date across all the rows of a column in Excel?
For example, I enter "0000-00-00 00:00:00" for the date and time and I place my cursor at the bottom right and click and drag to stretch the column down to duplicate it, the problem is I end up with 0000-00-00 00:00:01 in the second row, 0000-00-00 00:00:02 in the third row, etc.
Copying and pasting cell by cell works perfectly fine! The only problem is I have 110,000 rows and I don't plan to do this for the next 15 days lol
Does anyone have the solution?
Configuration: Windows 7 / Firefox 3.6.13
--
Close your eyes, and the world becomes what you want.
