Maybe I havent been clear- when I do this manually, it has no problem. It
is when I do this using VBA that the problem occurs- using opentext seems to
revert VBA to USA focus (regardless of the formatting I use i.e dmy etc...),
and so any dates it sees as US and defines dates outisde of acceptbal;e US
range as text.

Dave- maybe your a different version of Excel to me- I don't know. Frankly,
I would rather focus on why I have my problem then why you don't!


Any other suggestions?


"Dave Peterson" wrote:

Are you sure you choose the correct format for that field? mdy, dmy, ...

I've never seen excel fail to convert something that looked like that kind of
date to a date (during the text import).

jz193 wrote:

hi- thanks for the tip. I have already done this- the only way it works once
the macros is finished is to manually go into the cell and press F2 and
return. Any other suggestions appreciated.

"Pete" wrote:

Do it manually and record a macro while you do it. Set the column
formats for Date DMY as appropriate. Then you will be able to merge
bits of the recorded macro into the macro you have already developed.

Hope this helps.

Pete



--

Dave Peterson