Tim
Sorry for the delay - I have been on holiday for the past week.

The main database has a browser based report function. Once displayed in
the browser, the report is saved as a *.htm file. This is then pulled into
excel using a macro to clean up formatting issues (mainly merged cells).

I am pretty sure that the dates would not be an issue if the instance of
excel was running in US mode, it is just that my excel is in UK mode. Do you
know of any variables that can be set/reset within a macro to temporarily set
the programme in US mode?

Thanks


--
KenY


"Tim Williams" wrote:

How are you performing the import?

Tim

"KenY" wrote in message
...
Unfortunately, no. The system I am extracting from is used globally, so
the
extract/report would need to be different for each country format.
--
KenY


"Tim Williams" wrote:

Can you just do the date formatting in the SQL before it arrives in
Excel?

Tim

"KenY" wrote in message
...
Would appreciate any help on this one. Using Excel 2003 / Windows XP
SP2.

I import information from a database - this includes dates that are in
MM/DD/YYYY format. As I am in the UK, Excel's auto-features convert
some
of
the dates correctly, others incorrectly. I therefore use the
data/texttocolumns function to give correct dates - have done this many
times.