Right-click and drag.

Release the button and "Copy cells"


Gord Dibben MS Excel MVP

On Fri, 9 May 2008 14:30:00 -0700, dencara
wrote:

when I drag and drop a date format the day value increases by one. how do I
stop this? Thank you