On Thu, 30 Apr 2009 08:17:40 +0100, Simon Lloyd
wrote:

Hi Simon

Have you qualified .Cells(....etc?,

Yes

why not supply a bit more of your
code,

Fair enough, but it was just that line - or method failing. Ossie has
explained Format won't return a date.

which version of Excel are you using?, you say the value is
enetered as text have you added a ' for a text entry or is the cell
formatted as text?

2002 and the Cell is formatted as text. I found anything else caused
no end of trouble with auto-converting to ... something quite
different e.g. date to a number. Very frustrating!!

Cheers - Kirk