Excel 2002 Web Query screwing up en-GB dates

Good afternoon,

I have a web query in Excel 2002 going against a web page that returns a date column. The dates are returned as DD/MM/YYYY, 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.

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

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

Answers


Can you modify the "web query"?

The universal date format is the better way for Office products to recognise dates/times. I've had similar problems working with GB to US dates and found that coding your dates into this format saves you a lot of trouble.

Universal Date format is : "yyyy-mm-dd hh:mm:ss"

Need Your Help

Binary logic emulator logic error

c++ boolean logic

If you need any more information just ask.

Displaying š in textbox

php javascript ajax

I'm trying to display the character š in a textbox, but it's only displaying the other letters in the word. I'm grabbing data from a DB and, using json_encode, sending it via xmlhttp.responseText. ...

About UNIX Resources Network

Original, collect and organize Developers related documents, information and materials, contains jQuery, Html, CSS, MySQL, .NET, ASP.NET, SQL, objective-c, iPhone, Ruby on Rails, C, SQL Server, Ruby, Arrays, Regex, ASP.NET MVC, WPF, XML, Ajax, DataBase, and so on.