Here to help but I'm off on vacation for a few weeks
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"small tom" wrote
in message ...

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