Or maybe there's something else in those cells??

If you select that column and do
edit|Replace
what: / (slash)
with: / (slash)
replace all

do you get the dates you want--I'd test it by giving it an unambiguous date
format: January, 1, 2005 (say).

If it works, you could include that mass change in your code and walk away
happy???

wrote:

Thanks for your reply dave, Ive stepped through the code, and the
problem seems to when opening the file with vba. If i either open the
file using File/Open method the file opens and the dates colomn is as
it should be, or, if I just open the docs folder and double click again
its as it should be, but if I use the first line of code just to open
the file, the dates change there foremat some will = 01/01/2005 others
= 1/1/05. Ive looked for a pattern, eg particular months, but it pretty
random, It will do a complete month as 05, then the next month in
colomn as 2005. It seems to only change the year. I cna achieve what I
need to do manually, just got me curius as to why its doing this.
Regards Robert

--

Dave Peterson