Automatic conversion

B

Birdie

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Date formatting issue VB 0
Forcing a date entry format of dd/mm/yyyy 1
Publisher is filling blank lines with data 2
Excel date displayed wrongly 3
Delete Specific Rows Using VBA 3
date corruption? 00/01/1900 2
VBA: Copy a date and paste as text 3
Dates using Regional Options 2

Top