Unfortunately I cant alter the data on the way in as it comes from a web
query from a site I have no control over. Also preformatting the destinations
cells as text makes no difference, good old excel knows better and just turns
them back to date as the data comes in.

thanks anyway, it has forced me to brush up my VBA skills as I couldn't
stand seeing Manchester united beeting west brom by the 3rd of January any
longer!

"Peo Sjoblom" wrote:

There is no turn off for this, you can either preformat the cells as text or
precede the entry with an apostrophe '

--
Regards,

Peo Sjoblom

(No private emails please)


"ahughf" wrote in message
...
I run a web query that imports soccer results to Excel. Unfortunately the
web
site formats the result as 3-1 for example. This text is automatically
converted to 03 Jan by Excel. I can't seem to stop this happening, even if
I
explicitly set the cell format to text. Doing so just converts the
contents,
which were a date, to the internal date number and if I re load the data
it
reverts to 03 Jan again. Does anyone know how I might get excel to leave
the
format of the cells alone?

thanks ahughf