Conceding that XL2000 handled/handles this the way you want, seems to me that
if MYOB was correctly exporting the data IN EXCEL/XLS format, it'd be a date
serial number rather than a textual representation of the date. Date serial
numbers are unambiguous and not subject to misinterpretation


"KymY" wrote:

Within MYOB Premier 8, I save the report in Excel XLS format.
A screen version of the same report shows all dates in DD/MM/YYYY format.

Yet when the report is opened in Excel 2003, this problem occurrs.
(Note: Doesn't occurr with Excel 2000 (Service Pack 3))

Thanks for the script - has been a handy tool for fixes - however we often
export ledger data into Excel, usually with 5 - 10 accounts and 50 or more
transactions.
So fixing the data becomes quite time consuming.

Changing our PCs to use US date formats for our MYOB work is not an option
- due to high volume of transactions & multiple uers.

Problem seems to be the absence of a "Region"checking routine, when Excel
2003 reads a file.

MYOB are aware of the issue and working with MS on a fix - meantime, I can't
recommend Excel 2003. (Unfotunately our office dosn't have Excel 2000 - only
2003)

Gues this issue won't affect most US users - but it's a pain for others.