Hi,

The PC we are using was configured to UK settings. Therefore when
opening the spreadsheet with US dates anything that could be both a US
date and a UK date, was translated incorrectly to UK format (ie
06/07/2004 became 6th July 2004 rather than 7th June 2004).
Any dates that were not recognised as possible UK format dates were
formated as Text and therefore could not be converted back to UK (ie a
date of 07/24/2004 was automatically converted to Text and we do not
have 24 months in the UK callender.

The solution was to convert the PC's settings to US prior to opening
the document so that when the document was opened dates were recognised
as US format. As this point we saved the document and then reset the
PC's setting to UK and reopened the document. When doing this the
document was converted to UK format.

I hope this help anyonw with the same problem.

Regards

Matt


--
Emyn
------------------------------------------------------------------------
Emyn's Profile: http://www.excelforum.com/member.php...o&userid=16148
View this thread: http://www.excelforum.com/showthread...hreadid=470195