Automatic conversion

Birdie

Guest

Posts: n/a

2nd Jun 2008

I use the xmlHttpRequest (ajax) object to request XML data from a
website. The returned data contains dates formatted as strings (dd-mm-
yyyy). When I put this into cells, my English Excel version doesn't
recognise the input as dates. Apparently it expects a mm-dd-yyyy
format, although the regional settings of Windows are set to dd-mm-
yyyy. What can I do to fix this?

« UDF Macro Looping Issue Erroring out | Help w/Duplicates & Macros »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
automatic date conversion	=?Utf-8?B?VmluY2U=?=	Microsoft Excel Crashes	0	7th Jul 2006 04:37 AM
automatic conversion	=?Utf-8?B?dGhlc2hyaW5l?=	Microsoft Word Document Management	1	1st Mar 2005 09:00 PM
Automatic Value conversion	Dustin	Microsoft Excel Programming	3	15th Jun 2004 12:20 AM
Automatic conversion of whole # to decimal	=?Utf-8?B?Sm9saWU=?=	Microsoft Excel Worksheet Functions	2	22nd May 2004 09:23 PM
Re: automatic conversion	Pat Garard	Windows XP General	0	5th Sep 2003 06:31 AM