Hi all,
How do I stop numbers from increasing when I drag & drop ?
I'm trying to drag & drop a date but it keeps increasing as I drag & drop, i would like it to stay the same
eg its doing
1/1/2009
2/1/2009
3/1/2009
and I would like it to be like
1/1/2009
1/1/2009
1/1/2009
Regards
Daniel
put the same date in 2 cells select both then drag
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
Copy the cell you want.
Hightlight the range you want to copy in, press enter
Thank you very much !
Thank you very much also !!
Or, select the range and do CNTRL -D.
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks