"ShaneDevenshire" wrote in
message ...
Hi again,

I think maybe my last suggestion won't do what you want - instead
try this
Assuming the first entry is in A1 enter this formula in a blank
cell
=MONTH(a1)&"-"&YEAR(a1). Choose Copy, Paste Special Values.



Hi Shane,

I should have read down before replying to your first post!

Yes, I could use formulae (or code) after the import to correct the
issues, but I would really like to find a way to get excel to import
the data correctly if I can.

However, if that isn't possible, I may have to use a formula such as
that, so thank you for posting it.

The problem then would be that some of the cells are 'corrupted and
some are not, but I can work through the scenarios if I can't resolve
the underlying problem.

Thanks again!

--

Alan.

The views expressed are my own, and not those of my employer or anyone
else associated with me.

My current valid email address is:



This is valid as is. It is not munged, or altered at all.

It will be valid for AT LEAST one month from the date of this post.

If you are trying to contact me after that time,
it MAY still be valid, but may also have been
deactivated due to spam. If so, and you want
to contact me by email, try searching for a
more recent post by me to find my current
email address.

The following is a (probably!) totally unique
and meaningless string of characters that you
can use to find posts by me in a search engine:

ewygchvboocno43vb674b6nq46tvb