Hi
I've been having issues reading a date in a specific cell when the workbook is opened on a computer with French language settings.
The source data is in a XML file format, and the date is in this format 03/01/2011 12:52:01 PM. I'd like to remove the time and just have the date so I've used the INT() function which works fine when the workbook is opened on a PC with English settings, but generates a #Value! error when opened on a PC with French settings.
Any thoughts on potential causes/solutions to this?
I've tried saving the XML file as a Excel Workbook so that the data is no longer just a text string, but the same problem exists.
Thanks
I've been having issues reading a date in a specific cell when the workbook is opened on a computer with French language settings.
The source data is in a XML file format, and the date is in this format 03/01/2011 12:52:01 PM. I'd like to remove the time and just have the date so I've used the INT() function which works fine when the workbook is opened on a PC with English settings, but generates a #Value! error when opened on a PC with French settings.
Any thoughts on potential causes/solutions to this?
I've tried saving the XML file as a Excel Workbook so that the data is no longer just a text string, but the same problem exists.
Thanks