<p>Good afternoon,</p>

<p>I have a web query in <code>Excel 2002</code> going against a web page that returns a date column.  The dates are returned as <code>DD/MM/YYYY</code>, as I would like to show them in my spreadsheet.  My machine running Excel has its regional settings set to en-GB, and the only language set under Internet Options is UK English.</p>

<p>Nevertheless, the web query pulls the dates as <code>MM/DD/YYYY</code>, which is misinterpreted by Excel.</p>

<p>How can I get the Web Query to return the dates in my regional settings, <code>MM/DD/YYYY</code>?</p>

Maybe you are lucky and Excel understands either the HTML
```
lang
```
attribute or
```
<meta http-equiv="content-language" content="...">
```
meta tag. To be honest - my guess is that it doesn't make a difference.
If you have control over the web site, you can try to add them and see if it makes a difference. OTOH - if you
had
control over the web page, you could change the date format.
The alternative would be to disable date recognition entirely and post-process it by hand after the query. To do this, recreate the web query and in the "New Web Query" dialog box, click the "Options..." button in the upper right. There is a "Disable date recognition" checkbox.