Does sound like the value is getting stuck as text- possibly cos th
system is trying to read a UK format date (27/03/04) as a US Date (3r
of the 27th Month 2004). THis means vba fails to recognise the strin
as a date.

Maybe worth tring to set up the dates when running the text to column
command- and ensuring there are no " " round the date forcing it to b
text in the source data.

Dunca

--
Message posted from http://www.ExcelForum.com