| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automatic conversion
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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to disable automatic nr conversion | Excel Discussion (Misc queries) | |||
| Automatic Formula to Value Conversion | Excel Worksheet Functions | |||
| Automatic Currency Conversion | Excel Discussion (Misc queries) | |||
| Automatic CSV Data Conversion | Setting up and Configuration of Excel | |||
| Automatic Value conversion | Excel Programming | |||
Threaded Mode
