is there not a format mmm-yy
why not use it


Ankur wrote in message
...
i have column in worksheet for date for eg
| 15/06/05
| 15/07/05
| 15/08/05
|
| now monthwise i want to drag the column. Is it possible?
|
| this is in date format, also one more column
| June 05
| July 05
| Aug 05
|
| The date will remain same
| Thanks in advance