Thanks - think I just sorted it by starting at the point you gave me.
This still didn't quite work as it changed it to mm/dd automatically
but I went in and swapped it to 14-march-05 and now it will autofill
when dragging it. Thanks for the point in the right direction - am sure
I will be bothering you again.
Tom
--
small tom
------------------------------------------------------------------------
small tom's Profile:
http://www.excelforum.com/member.php...o&userid=27828
View this thread:
http://www.excelforum.com/showthread...hreadid=473342